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
@neg177
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.
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.
@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.
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!