Fiscal period for reports

[Former Member]

Hello Experts,

Recently I was given a task to identify the Plan values for Current Year by calculating the Average of the Actuals of the Previous Two Years. I was able to achieve this task by writing a Logic Script with some guidance.

Now this task has been modified and I have been asked to do the same thing but using Fiscal period. So instead of identifying the Plan data for the current Calendar Year, I have to identify the same using the current Fiscal Period by calculating the Average of the Actuals of the Previous Three Fiscal periods. I want to understand how to setup the Time Dimension based on our Fiscal period, which is Apr-01 to Mar-31.

Note: Please find the snapshot of the Time Dimension.

Kindly advise.

Regards,

Mario.

[former_member186338]

Hi Mario,

If you have fiscal year different from calendar - then your time hierarchy will be based on fiscal year. Please search the forum for the samples. You can simply change the description of months

Vadim

[Former Member]

You mean, changing description of Months in the Time Dimension? Am I correct?

[former_member186338]

Yes Please search!