08-13-2024 05:35 AM
currently we are using standard time profile, we are planning to change the time profile to 5-4-4.
does it affect historical data? how can we achieve changing time profile?
08-13-2024 07:57 AM
Is the business looking to change from monthly (standard), calendar reporting to weekly or both?
08-13-2024 08:00 AM
business looking to change form monthly(standard) to both
08-13-2024 10:33 AM
On creation of the application was weekly and monthly considered? Within the "Standard" time profile do you have weeks and months?
08-13-2024 10:41 AM
i have months within standard
08-16-2024 01:59 PM
Are you asking if you can change the current Standard time profile to 5-4-4 from its current setting?
OR do you want weeks to show up in the Time dimension? (e.g. 2024W26)
If it's the former, the Fiscal Year Month Type setting affects any apis that return the number of days in the period (e.g. api.Time.GetNumDaysInTimePeriod). So any rules or member formulas using them would be affected by changing it to 5-4-4, including the calculation or consolidation of historical periods.
If it's the latter, you'll need to create a new application because a time profiles must be created prior to the application being set up. You could use the old application as a data source for the historical monthly data and load that into the new application to a Scenario defined with a Monthly Input Frequency.