Primavera Data Warehouse can use two additional financial periods.
Note: You must have previously run the STARETL process.
To add the additional financial periods to your Primavera Data Warehouse:
- Sign in to the Primavera Data Warehouse database instance as the schema owner. For example, the STARUSER account.
- Run a query to set the values for fin_period_2 and fin_period_3.
For example:
update w_day_d set fin_period_2 = CHR(64 + cal_month)||'-'||cal_year;
update w_day_d set fin_period_3 = CHR(64 + cal_month)||'-'||cal_year;
Enter these queries as one line.
- Commit these changes.
- Run the STARETL process.