web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Sales analysis report

(0) ShareShare
ReportReport
Posted on by 130

In "Sales analysis" report (Sales and marketing/Reports/Sales management/Sales analysis) drop lookups "Sales person" and "Sales unit" are empty.

Settings made:

In Query administration data was created using "Create default data"

3582.Query_5F00_administration.png

Sales unit/team was created in Setup (Setup/Sales management/Sales unit team) but after cube was processed.

6215.Sales_5F00_unit_5F00_team.png

After that, we processes the sales and marketing cube again, but both drop lookups are still empty.

At the same time, when we open this report in Report Designer Visual studio using the preview mode both drop lookups have values.

How to fix this issue?

*This post is locked for comments

I have the same question (0)
  • Borys Bayramukov Profile Picture
    130 on at
    RE: Sales analysis report

    Settings made:

    Querry administration

    Sales_5F00_unit_5F00_team.png

    Sales unit team

    Sales_5F00_unit_5F00_team.png

  • André Arnaud de Calavon Profile Picture
    297,830 Super User 2025 Season 2 on at
    RE: Sales analysis report

    Hi Borys,

    Did you try to include screenshots? If so, please try to upload them again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Community Member Profile Picture

Community Member 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans