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! :)
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
