Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Trying to get a null A...

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

(0) Share

Report

Posted on by Community Member 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

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

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"