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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Retail Cube Reports
Microsoft Dynamics AX (Archived)

Retail Cube Reports

(0) ShareShare
ReportReport
Posted on by Vino9667 364

Hello friends,

Retail Sales Metrics reports showing the the Organization unit as N/A and Unknown only with the results.

Sales Performance by category by store showing all data for 1st legal entity correctly, am having another legal entity but this report is not showing 2nd legal entity.

Top 10 OU Performers in current year report show data but with Retail channel name N/A for second legal entity.

Trend by operating Unit report not showing in second legal entity.

anyone can you guide me to solve this issue or am I missing any configurations.

*This post is locked for comments

I have the same question (0)
  • Nirmal Raja Profile Picture
    Nirmal Raja 4 on at

    Hi Vinod,

    We are also facing the same output on this report N/A and unknown, i tried to Change Organization Hierarchy Purpose - Retail reporting and set as default but no difference.

    Please share if you have any solution, that would help us.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Nirmal Raja,

    Here is the AX2012 retail cube reference site:

    docs.microsoft.com/.../retail-cube-retailcube-for-microsoft-dynamics-ax-2012-r2-and-r3

    Do you use this cube?

    Have you added/modified something?

    I guess that some configurations/setups are missing that cause the N/A output. If you look at the how the output is calculated, you should be able to identify the missing configuration/setup.

    Best regards,

    Ludwig

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    There are 99% chances of having value N/A in any cube. What N/A is..? it means not applicable.

    Imagine you have list of sales orders, with each order having a Region so data will be divided something as following

    Region Total Sales
    EU 100
    Asia 120
    America 47

    But what if few sales orders are not having the value for this field Region. Here how the result would be.

    Region Total Sales
    EU 100
    Asia 120
    America 47
    N/A 87

    Cube categorizes the data always with unknown/NA value, though this behavior can be modified by modification of queries in SSAS.

    I don't think having N/A should be problem.

    I would encourage you to re-process your cubes from SQL server.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans