The first step in configuring the repository in Oracle Business Intelligence (OBI) is to verify or change the database instance alias, which was previously set up within the tnsnames.ora file, for connection to Primavera Data Warehouse.
If needed, complete the following steps to verify or change the Primavera Data Warehouse connection alias:
- 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, select Manage, Variables.
- In the Variables Manager window, on the left pane, select Repository, Variables, Static to modify the static repository variable.
- On the right pane, double-click the line with DW_DSN in the Name column.
- In the Static Repository Variable – DW_DSN window:
- In the Type section, set the Type option to Static.
- In the Default Initializer field, change the 'STARDW' value to the correct alias for the Primavera Data Warehouse instance. Be sure to enter single quotation marks (') around the alias.
Note: This name should correspond to the name used in the tnsnames.ora file to identify the Primavera Data Warehouse database. See Updating the tnsnames.ora File with OBI for details.
- Select OK to close the Static Repository Variable – DW_DSN window.
- In the Variable Manager window, select Action, Close to close the Variable Manager window.
- Select File, Save to save the repository.
Note: If you are prompted to check file consistency, click No.
Remain in the OBI Administration tool and continue to the next topic.