Tables and Cubes Are Affected For A Given Stage Table

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

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk