Dimensionality
Hi,
I would like to know what is the best approach for building when you have repeated Line Item's. How should you Dimension your Module? Attached is a screen shot of what I'm trying to replicate in Anaplan.
Thank you
Best Answers
-
Super straight forward. All you have to do is ask yourself what makes the Monday-Friday sections unique. Create a list with those unique values then add it to your "applies to". In your case you'll nest it with M-F as a row.
Worst case scenario, you can make up a list, like "1", "2". but that doesn't look as nice.
1 -
Yes as @JaredDolich mentioned, this should not be too hard to accomplish.
From the screenshot it appears you have a few chunks of Monday-Friday’s in a month.
If you are able to provide some more insight @neg177 into the meaning behind each Monday-Friday grouping in your screenshot we could perhaps provide more specific guidance. There seems to be a component of Daily Funding but hard to decipher what the rest of the chart is showing exactly.Notice some averages/aggregations/variance analysis but perhaps you have more business context.
1 -
@neg177 agree with @JaredDolich as he provides the simplistic explanation towards the solution..... Appreciate @JaredDolich
To shed a light on the problem statement, @neg177 you have to decide a list (kind of metadata) and by looking into the provided screen print it is Monday to Friday as values in the list and a time dimension in the upcoming module (month wise).
Looks like 3 row items needs calculation (screen print below) so create those as line items in the upcoming module and use the appropriate formulae
I hope with that you will get the base of your module unless anything else to be tweaked as per need.
0
