Scenario Example: New Dimensional Data / New Fact and Dimensional Data

A request has been put in to upload a new Stage_Title and Stage_Account file.

  1. Upload the files to their appropriate tables.

  2. In Generate DIL, select "Dimensional Data" for the option in "Please Specify What Data Changes Occurred in Staging"

  3. Select Stage_Account and Stage_Title in the dimensions list box. Then select Stage_FTE_Fact and Stage_GL_Data in the fact tables list box.

  4. Click on Step 1: Validate Staging Data.

  5. (Assuming no validation errors) Select "Build Dimensional Data, Deleting All Existing Members."

  6. Select the FTE_Fact and GL_Journal_Entries_Fact table.

  7. Click on Step 2: Generate Data Integration Layer.

  8. FTE_Fact, GL_Journal_Entries_Fact, their dimensions, and all fact tables that share their dimensions are rebuilt.

  9. Click on proCube Functions.

  10. Log onto the configured proCube server.

  11. Select Xchange GL Data and Xchange FTE, select "Add Metadata and Refresh Fact Data" option.

  12. Click the Rebuild Cubes button.


What did we just do? A dimensional data change alone means an impact to potentially multiple fact tables as listed above. The process above would be similar in doing the process for both a fact and dimensional data load. In the case that the fact data being refreshed is separate from the dimensions being refreshed, the user only needs to select a dimension that affects the fact table in order to get it to appear on the fact table list.


Steps 1-3 involves loading the data to Stage tables and validating the data in the Stage tables. Steps 4-5 rebuilds the DIL tables from their Stage tables. Finally, steps 6-7 rebuilds the proCube databases from their DIL table sources.


Please sign in to leave a comment.
Powered by Zendesk