Scenario Example: New Hierarchical Data (Stage_GL_Rollups)

This only applies to a new Stage_GL_Rollups file. Stage_GL_Rollups was designed so that hierarchies for GL Accounts would not need to be defined on a row-by-row basis. The Stage_GL_Rollups file defines accounts in ranges, and as a post-load operation, updates the accounts in the given ranges with the properly defined hierarchies. So, intuitively, Stage_GL_Rollups is more a "subset" of Stage_Account

  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 in the dimensions list box.

  4. Select Stage_GL_Data in the fact tables list box.

  5. Click on Step 1: Validate Staging Data.

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

  7. Select theGL_Journal_Entries_Fact table.

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

  9. GL_Journal_Entries_Fact, its dimensions, and all fact tables that share its dimensions are rebuilt.

  10. Click on proCube Functions.

  11. Log onto the configured proCube server

  12. Select Xchange GL Data, select "Add Metadata and Refresh Fact Data" option, then check off "Rebuild Hierarchies."

  13. Click the Rebuild Cubes button.


What did we just do? Since Stage_GL_Rollups fundamentally changes the hierarchical structure of the Account dimension, in proCube, we must specify a "Rebuild Hierarchies" when rebuilding Xchange GL Data.



Please sign in to leave a comment.
Powered by Zendesk