The table below will describe what tables and cubes are affected for a given Stage table.
Note that, based on what Stage fact tables you validate, the Generate Integration Layer step can identify what DIL tables will need to be rebuilt as a result, and the Rebuild proCube step will preselect the cubes to rebuild based on what DIL fact tables that were rebuilt.
Files identified as Fact files won't need dimensional data rebuilds when selecting Dimensional Options in Generate DIL. However, if new dimensional files are loaded, dimensional data will need to be rebuilt in the Dimensional Options, and the fact tables that relate to the dimensions that change will need to be re-validated.
Upload Data to Stage Table |
Type of Data |
Generate DIL Fact Tables to Rebuild |
Cubes to Rebuild |
Stage_Account |
Dimension |
GL_Journal_Entries_Fact |
Xchange GL Data |
Stage_Asset_Class |
Dimension |
Asset_Data_Fact |
Xchange Asset Data |
Stage_Asset_Data |
Fact |
Asset_Data_Fact |
Xchange Asset Data |
Stage_Currency |
Dimension |
All fact tables |
All Xchange cubes |
Stage_Employee |
Dimension |
Employee_Data_Fact, FTE_Fact, Timekeeper_Rates_Fact |
Xchange Employee Data, Xchange FTE, Xchange TK Rates |
Stage_Employee_Data |
Fact |
Employee_Data_Fact |
Xchange Employee Data |
Stage_FTE_Data |
Fact |
FTE_Fact |
Xchange FTE Data |
Stage_GL_Class |
Dimension |
GL_Journal_Entries_Fact |
Xchange GL Data |
Stage_GL_Data |
Fact |
GL_Journal_Entries_Fact |
Xchange GL Data |
Stage_GL_Rollups |
Dimension |
GL_Journal_Entries_Fact |
Xchange GL Data |
Stage_GL_Type |
Dimension |
GL_Journal_Entries_Fact |
Xchange GL Data |
Stage_Office |
Dimension |
All fact tables |
All Xchange cubes |
Stage_PG_Dept |
Dimension |
FTE_Fact, GL_Journal_Entries_Fact |
Xchange FTE, Xchange GL Data |
Stage_Salary |
Dimension |
Employee_Data_Fact, FTE_Fact, Timekeeper_Rates_Fact |
Xchange Employee Data, Xchange FTE , Xchange TK Rates |
Stage_TK_Rates_Data |
Fact |
Timekeeper_Rates_Fact |
Xchange TK Rates |
Stage_Title |
Dimension |
FTE_Fact |
Xchange FTE |
Stage_WIP_AR_Data |
Fact |
WIP_AR_Fact |
Xchange WIP AR Data |
0 Comments