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
@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.
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!
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?
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! :)
what are these? when do you use them? why one over another? thanks Data types string long float bool date datetime datetimetz
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
