Primavera Data Warehouse can use two additional financial periods. Use the following procedure to add the additional financial periods to your Primavera Data Warehouse:
Note: You must have previously run the STARETL process.
- Log 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.