Is that possible to customize the time scale text?

Users export forecast report every day, they are wondering if the time scale here e.g. "Week 1 FY25" could be "Week 1 FY25 (2024-09-29)" which add a START date of this week, otherwise they have to manually add it in the excel file.

Thank you

Accepted answers

lokeshm

@BruceSonos create system module with weeks as dimension and use the formulas to create your custom week name . In this case I have created like this.

Now create a Custom list and add Weeks dimension and import Combine line item into your list .

Now you can use this list in the module to show your reporting. Refer the week data from the time dimension module by using lookup of Week mapping . Hope this helps.

All comments

AjayM

Hi @BruceSonos ,

You can't do that with native time dimension unfortunately. You will have to introduce custom time dimension (a numbered list preferably) for the reporting/export purpose, to achieve dynamic renaming of time items.

Cheers!

BruceSonos

Hi @AjayM

Thank you for your reply, regarding the custom time dimension you mentioned, could give me a high level guidance? How could I apply it for the reporting/export purpose?

lokeshm

@BruceSonos create system module with weeks as dimension and use the formulas to create your custom week name . In this case I have created like this.

Now create a Custom list and add Weeks dimension and import Combine line item into your list .

Now you can use this list in the module to show your reporting. Refer the week data from the time dimension module by using lookup of Week mapping . Hope this helps.

devrathahuja

Hi @BruceSonos ,
You could use the label option of week commencing instead to get the start date-

The time dimension across the model would look like this in that case-

Hope this helps! :)

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385