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

ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…