Scenario Example: New Fact Data

A request has been put in to upload a new Stage_TK_Rates_Data file.

  1. Upload the file to its appropriate table.

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

  3. Select Stage_TK_Rates_Data in the fact tables list box.

  4. Click on Step 1: Validate Staging Data.

  5. (Assuming no validation errors) Select "Do Not Build Dimensional Data, Just Build the Fact Table(s)."

  6. Select Timekeeper_Rates_Fact.

  7. Timekeeper_Rates_Fact, its dimensions, and all the fact tables that share its dimensions are rebuilt.

  8. Click on proCube Functions.

  9. Log onto the configured proCube server.

  10. Select Xchange TK Rates, select "Add Metadata and Refresh Fact Data" option.

  11. Click the Rebuild Cubes button.


What did we just do? If only a fact table changes, there is no need to refresh dimensional members in the DIL.



Please sign in to leave a comment.
Powered by Zendesk