Once a rollup fact table has been defined in the metadata and created in the database, an update procedure can be generated to handle the update of the fact table.
Note: You can also generate an update procedure via a template, refer to Rebuilding Update Procedures for details.
Generating a Procedure
- To generate a procedure, right-click on the fact table in the left pane and select Properties to edit the properties for the fact table.
- Click the Rebuild button to start the process of generating the new procedure.
- A series of prompts are displayed during the procedure generation based on the type of load information.
Define Rollup date dimension and column
The first dialog displayed when generating a detail fact table update procedure is the defined rollup date dimension and column window:
RED needs to know which date is driving the rollup and to which level of detail we wish to set as our base.
In this example, we have chosen dim_ship_date as our date dimension and ship_cal_month as our rollup column to set the level to summarize all transactions. Click OK.
RED also needs to understand which date field in the actuals should be used to base the rollup; we have chosen dim_ship_date_key and click OK.
Once again, select the date dimension key and click OK.