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.
Upload the files to their appropriate tables
In Generate DIL, select "Dimensional Data" for the option in "Please Specify What Data Changes Occurred in Staging"
Select Stage_Account in the dimensions list box. Then select Stage_GL_Data in the fact tables list box. Click on "Step 1: Validate Staging Data"
(Assuming no validation errors) Select "Build Dimensional Data, Deleting All Existing Members", and select theGL_Journal_Entries_Fact table. Click on "Step 2: Generate Data Integration Layer"
GL_Journal_Entries_Fact, its dimensions, and all fact tables that share its dimensions are rebuilt
Click on proCube Functions, log onto the configured proCube server
Select Xchange GL Data, select "Add Metadata and Refresh Fact Data" option, then check off "Rebuild Hierarchies," then 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