If you configured additional Financial Periods for use with Primavera Data Warehouse when you installed Primavera Data Warehouse, some additional steps are required to make these additional Financial Periods available in Oracle Business Intelligence (OBI).
To configure OBI to use the additional Financial Periods, complete the following steps:
- Launch the OBI Administration application.
- In the OBI Administration application, select File, Open, Offline.
- Select OraclePrimaveraAnalytics.rpd and click Open.
- Enter the password for the OraclePrimaveraAnalytics.rpd file (by default, Admin123).
- In the far right section (Physical), go to the W_DAY_D table.
- Select the FIN_PERIOD_2 and FIN_PERIOD_3 fields, drag them to the middle section (Business Model and Mapping), and release them in the Dim – Date dimension.
- After FIN_PERIOD_2 and FIN_PERIOD_3 appear in the Business Model and Mapping section under the Dim – Date dimension, you can drag them to the left section (Presentation) where you want them to appear in OBI. You can also rename them there, so they display as you require.
- Save OraclePrimaveraAnalytics.rpd.