Top Level Aggregation while Using Line Item Filters
Hi Anaplanners ,
I would appreciate if someone in the forum could help me to resolve the below modelling issue that i have.
I have 4 dimension on which the business needs to do their planning ,forecasting process- Segment, Legal Entity, Department and Account. These dimensions are independent of each other and don't have a parent-child relationship.
When i start to build a module with these dimensions along with Dummy Versions and Time the model size blows up heavily.
I then started to create a combination list from code of these dimension to hold my values from Source and provided Line item filters for Users to see the data based on their Selection. Users could see the data based on whatever they select expect that when they select the Top Level items the data does not aggregate.(see Screenshot 1 and 2)
Can someone help to find a workaround for this?
Thanks in Advance