Hello, Please do let me know if there a way to rename the Time period Label of Year? For eg FY2015, FY2016 etc. to 2015 or CY2015. Thanks, Suneesh
There are two contexts for examples:
For item 1, the only way to change the format of the native timescale column header is to use a false time dimension (for the related reports and map Anaplan time periods into the false time periods). In this case, it might be addressed as follows:
I'm a little short on time today, but let me know if you want an example, I can dig one up.
That's very helpful. We would need to rename the standard Anaplan FYxx to Year1, Year2, etc.
It seems the first approach I tried was the one you mentioned on point 1 but I was struggling to get the lookups to work.
If there was an example I could look at, that would be super !
Thanks a million for your help.
Steps to acheive your requirement:
1. Create a dummy time period list (List members will be 2015, 2016, 2017 etc)
2. Create a property in the list created above, say e.g i will name the property as "Anaplan Time Period". And Format that property to "Year".
3. Mannually map the Anaplan time to newly created list.
4. Use the new list created in your reporting modules. And, bring the values from modules using anaplan default time by looking to "Anaplan Time Period" property created above.
Hope this helps.
CA Pavan Kumar
Here's a simple example showing how to aggregate Native Anaplan Time data into a False Time (reporting) module (attached).
Very interesting, I will take a better look at it tomorrow !
I might have a question you could easily help with :')
@PaulRitner, thanks a lot for sharing that approach. I still need to review the attachment :) My first impression is that I might be able to use it in the future but I need to fully understand it and run some tests. If I understand it correctly you have re-engineered the aggregation on a false time dimension.
On the specific use case I'm working on I decided to use the time dimension because there were too many time-specific functions I wanted to make sure I could use eg cumulative, previous, next and others....
I therefore thought the easiest approach was to "plug in" reporting modules at the end and relabel the time accordingly using a list/property.
However :-) I've got one last specific example I'm struggling with : this time the relabelled time is on an Input module and the fake time dimension is on the "across", not on the "down" dimension....
Attached picture should give a feeling of what I've got...I was planning to create a module dimensioned by the fake year dimension and then amend the current one to lookup the value typed in by the user. However, it seems I'm failing miserably on the lookup. It seems I'm missing something obvious. Any clues or hints&tips ?