You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SET AGGMISSING On eliminates zero level data

Received Response
28
Views
6
Comments
edited Nov 13, 2018 5:41PM in Planning 6 comments

Summary

Creating 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.

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!