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