I want to show comparison for two years ( 2018 2019 ) in the columns and months in the rows ( jan till december ). I cannot find how to do that ( I am using the time dimension of Anaplan not seperate created year and month dimensions as lists.
The only way to do this is by using lists (and not using Anaplan Time).
If I were building this, there would be two lists:
1. Years (this might include just the two years you are interested in, but could include a 3rd item for Variance).
2. Months (just the 12 months of the year and a Year Total if applicable)
When you create the module, ignore Anaplan Time, and include Years, Months, and whatever other dimensions you need. Then pull the data in via formula... this can be done by adding a line item at the intersection of Year & Month to calculate the related period. If you are using a Variance item in the Years List, then search for it and augment the data formula to calculate the difference.
Thanks Paul.
I have indeed seen several models where the Anaplan Time dimension is not used. I understand the impact on model size, but I am interested to learn what the advice is when to use . In my case, I do not want to loose the advantages the Anaplan time brings, because it brings so many advantages ( and my formula knowledge and practice is probably not so advanced ). It seems like developpers are re-building the time dimension which looks like a unneccessary effort ( except in cases like mine ). I have now solved it by creating multiple views ofthe same module , with the different years shown on the dasboard ). I admit this is not a beautifull solution.
Is there anything written on when to use the anaplan time and when to design it yourself ?
Hi,
I avoid using custom time lists, unless its one of the following cases:
The reason I avoid custom time lists is directly related to your comments... that working with native time is so much easier.
For read-only reports, its typically the end of the line (in the sense that the read-only report isn't referenced by another module)... This is why its ok (from a model scaling perspective) to use false time.
Lastly, its not so much that I have a problem working with false time... its that the client has to take ownership of the model (and using native Anaplan Time makes things that much easier).
Cheers!
Hi everyone, I'm trying to use this function on specific members of my grid, as described in the documentation. In my example, the grid contains two row elements: ACTIF and PASSIF. The problem is that when I use this function, it affects all elements in the grid, whereas I only want it to apply to the specified member:…
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
