Creating Combination list from Module with 6 Dimension
We have a module with 6 dimensions including time, we have to make a staging list from this module at combination level to store the previous data.
For this we need only non-zeros combinations to be created in the staging list.
Each line item in the existing module is taking ~10-12 GB space therefore we have the summaries as "None"
- In Anaplan only 3 dimesnsions can come in the rows in the pivot view, rest have to be either moved to col. or pages.
Filters are only getting applied to the dimensions that are in rows
- The dimensions that are in pages, Anaplan is only making combinations for the selected item in that particular dimension.
Eg. If we have channels in pages and Channel A is selected then combination will only be made for Channel A similarly combination is only getting made for a month that is selected.
- If we take time in combination of properties then~16 combinations are made for each set i.e. 12 for every month , one for FY and for quarters as well.
Please let us know the feasible solution, treat this as priority as this is really urgent