Changing the labels of Time Dimension

All - I am using time dimension in one of my modules. The default behavior of the Anaplan puts the time dimension in a format Jan 20, Feb 20 etc. However, due to data integration capability I have a specific requirement that I want to display months in format only Jan Feb etc. The year has to be different line. Below is an example what I am trying to accomplish. Any pointers will be helpful

FROM

Jan 21	Feb 21	Mar 21	Apr 21
100	200	200	250

DESIRED RESULT

FY 21	FY 21	FY 21	FY 21
Jan	Feb	Mar	Apr

Accepted answers

All comments

ChrisAHeathcote

@AvnishGoel

It is not possible to change how time is displayed.

However, what you can do is create a Months list and using time period year and this new list when creating your modules.

While this will solve this immediate issue it may also cause more problems later.

This is because there are many very useful functions which only work when the module is dimensioned by time.

There are workarounds for many of these but consider it before deciding on this solution.

ashish.banka

@AvnishGoel I am just wondering if you can work with the data integration team as Months data without year does not make sense. If you have months and years in different columns in the source file, I would assume you can work with them to include Month and Year to be concatenated before loading into Anaplan module.

If that does not work, I guess, I would go with @ChrisAHeathcote suggestion as a work-around.

Hope this helps.

ChrisAHeathcote

@ashish.banka

To elaborate on my suggestion.

I recommend that you import your data using Anaplan time. Then map you import into a new module dimensioned by the new Month list and Year time.

Utilise the native time dimensionality to facilitate an efficient data import then manipulate the data for presentation.

This will ensure that you can reference the data efficient using Anaplan time functions which will not be possible if you import directly into the months list.

Quick Links

Can you help?

Unanswered questions

Replace a line Item in the whole model
Is there any easy way to replace a Line Item in the whole model in all formulas? right now i have to check hundreds of modules to switch out a Line Item, which is quite tedious //GP
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…