SET AGGMISSING On eliminates zero level data
SummaryCreating a Demo, the client requested a dimension called "Ledger". Once SET AGGMISSING ON was set, it deleted all zero-level data in this sparse dimension.
Creating a demo for a client, there was a need for a dimension called "Ledger". We created the dimension as Sparse along with others dimensions for the demo. On one of our calculations, we had to use SET AGGMISSING. We we set to "On" and ran thru the calculation, all the level 0 data for that dimension was cleared.
It happened numerous times which had us confused. We eliminated the application and recreated adding one custom dimension at a time, and when we got to "Ledger", we realized this was causing the issue.