Included with the STARETL process, some fields are calculated and stored in Primavera Data Warehouse based on predefined calculations. These calculations can be changed to meet specific business requirements.
To view the predefined calculations, complete the following steps:
- Log in to Primavera Data Warehouse (with SQL Plus, SQL Developer, and so on) with the user account for the schema owner (for example, STARUSER).
- Run the following command:
Select * from etl_calculations;
The output from this sql statement shows the following columns:
- TABLE_NAME: This is the table name where the calculation will be stored
- COLUMN_NAME: This is the column name for the calculation
- CALCULATION: This is the actual calculation which is used to create the data in the column
- DEFAULT CALCULATION: This field shows what the calculation for this column is/was for the default out-of-the box calculation.
- DATA SOURCE ID: This is the data source id for the calculation.
The following Primavera Data Warehouse can have calculations:
- W_ACTIVITY_HISTORY_F
- W_WBS_HISTORY_F
- W_PROJECT_HISTORY_F
- W_ACTIVITY_WORK_DOWN_HF
- W_ASSIGNMENT_WORK_DOWN_HF
Note: You cannot add additional rows to this ETL_CALCULATIONS table.