Verifying the Primavera Data Warehouse Schema Owner with OAS

The second step in configuring the repository in Oracle Analytics Server (OAS) is to verify or change the database schema owner, which was configured during the installation of Primavera Data Warehouse. See the Primavera Data Warehouse Installation and Configuration Guide for details.

Note: If you are already logged into the OBI Administration tool, skip steps 1 through 5 of this procedure.

Complete the following steps to verify or change the Primavera Data Warehouse schema owner:

Launch the OAS Administration tool.
Select File, Open, Online.
Select the OAS DSN for your OAS.
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_USERNAME in the Name column.
In the Static Repository Variable – DW_USERNAME window:
1. In the Type section, set the Type option to Static.
2. In the Default Initializer field, change the 'staruser' value to the schema owner for the Primavera Data Warehouse instance. Be sure to enter single quotation marks (') around the value.
Select OK to close the Static Repository Variable – DW_USERNAME 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 OAS Administration tool and continue to the next topic.

Related Topics