...

We have prepared the script in a Stored Procedure sp_create_calendar. Select the stored procedure:
Image Added, then do a right mouse click and select Modify:

The following script will appear:

Image Added

This script can be used to define various calendars. To generate a calendar with a Half Year / Quarter / Month layout:

• select the first block ('truncate ...') and press F5. This will clear the current calendar table.
• then select all lines in the 2nd block and press F5
• you can then close the window. Ignore the requests for saving.

In the comment-area you can see an alternative calendar: only a Quarter level and the months abbreviated to 3 characters. Of course, you are free to change the layout, for example to accomodate a broken fiscal year.

There are a few rules attached to this script:

Load Sets

The Load Sets determine the combination of Scenarios, Years and Periods that will be extracted from HFM.

...