The third step in configuring the repository in Oracle Business Intelligence (OBI) is to enter the Primavera Data Warehouse schema owner password.
Note: If you are already logged into the OBI Administration tool, skip steps 1 through 5 of this procedure.
Complete the following steps to enter the Primavera Data Warehouse schema owner password:
- Launch the OBI Administration tool.
- Select File, Open, Online.
- Select the OBI server DSN for your OBI server.
- Enter the repository password (by default, Admin123).
- Enter the WebLogic administrator username and password.
- With the repository open, do the following to update the password:
- In the Physical section on the right, right-click the physical connection source (by default, Oracle Primavera P6 Data Warehouse) and select Properties.
- Select the Connection Pools tab.
- Double-click the Oracle Primavera P6 Data Warehouse Connection Pool.
- On the General tab, on the same row as username, enter the password for the Primavera Data Warehouse schema owner.
- Click OK and re-enter the password to confirm the change.
- Click OK to close the Connection Pool - Oracle Primavera P6 Data Warehouse Connection Pool window.
- Select File, Save to save the repository.
Note: If you are prompted to check file consistency, click No.
Remain in the OBI Administration application and continue to the next topic.