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
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"
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156