Set Variables

[Anonymous]

I have the following calendar script:

I then use the PeriodID, MonthID and QuarterID to create set variables for year to date, month to date etc as per the attached script.  I have added a fiscal calendar to the Master Calendar and now want to adjust the attached set variables to do the year to date, month to date etc using the fiscal dates.  How can this be accomplished?

Regards

[santiago_respane]

Hi Christopher,

where are you using those expressions?

Are you using set analysis in the loading script?

Please elaborate more in order to be able to help you!

Kind regards,

[jonathandienst]

Just create 3 more fields in the topmost LOAD step using the fiscal year, quarter, month and week fields from preceding load step using the same logic as the existing calendar ID's.

[Anonymous]

Many thanks Santiago

I load the script at the back end of the app as below and use set analysis on the front end with the loaded variables as follows:

[Anonymous]

Thanks Jonathan

I have done it as follows:

I am not quite sure how to approach it for the fiscal year, i.e. generate the PeriodID for the fiscal year

Regards.