...

Note that copying the metadata has to be done each time the dimensions of HFM has changed (added / removed / moved members of a dimension)

Create a Calendar

After retrieving the meta-data for the first time, we still have to perform one manual step: fill a table in the cxo_hfmexressstaging_... database with the specifications of the calendar.

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

Load Sets

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

...