Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Trying to get a null AX financial dimension value to show up in AX cubes as N/A in AX 2012 R2

Posted on by Microsoft Employee

Hello All,

I am currently working on a AX SSAS cube project where there are a number of transactions where one or more financial dimension values are blank (or null in the SQL database).

I am trying to find a way to have this data show up in a cube report with a value of n/a when the report is run by the missing dimension, but it currently appears that this data is missing in the lower level tupples, while still showing up in the total at the bottom of the cube report in excel.

For example, I have 100k of transactions, and 10k of them are missing the dimension value.

My excel report is showing at the line level only 90K worth of transactions, but the report total is showing the full 100k.

Does anyone have any thoughts on how I could get the SSAS cube to return n/a instead of just ignoring a null dimension?

thanks,

Phil

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trying to get a null AX financial dimension value to show up in AX cubes as N/A in AX 2012 R2

    Determined that this was due to the financial dimension being its own dimension in the SSAS cubes where the query was only looking valid dimensions in the first place.

    In effect, the SQL was looking at valid dimension values - > the sales order view meaning that the cube could never really "see" the dimensions I wanted marked as "N/A"

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans