3.4 OBIEE Artefacts

OBIEE Artefacts

This section assumes a basic familiarity with OBIEE and it’s application and deployment screens.  It also assumes that the user has access to a windows machine running the OBIEE Administration Tool.
First you should validate that your installation package contains both units of required media.  There should be two files present in  $OHI_ROOT/reporting/

• VBP.RPD
• OHI_Value-Based_Payments.catalog

These represent the two units of configuration for all OBIEE artefact deployments.  The first is the reporting layer ( VBP.RPD ) which contains the mappings of tables and views used to create analytics reports and dashboards in OBIEE.  The second is the catalog file which contains the configured dashboards and reports along with other configuration built on top of the reporting layer.

Deploying the Reporting Layer

The reporting layer needs to be deployed to the target OBIEE server first.  Deploying the Reporting layer consists of two phases.  In the first phase you use the OBIEE administration tool to modify the datasource configuration of the RPD file to match the target environment.  The OBIEE RPD file is provided with the deployment files, and be located at $OHI_ROOT/reporting/VBP.RPD as indicated above

Modify the RPD Connection Information

Modify Connection – Use the OBIEE Administration tool to change the Value-Based Payments and Value-Based Payments Variables connection strings to be correct for the target environment.

1. Start the OBIEE Administration tool
2. Open the VBP.RPD File, this will Require the RPD password distributed with your installation package.
3. In the "Physical" Window, Right Click on OHI Value Based Payments -> OHI Value Based Payments and Select Properties
4. Change the value of the field "Data Source Name" to match your target environment, and select OK
5. In the "Physical" Window, Right Click on OHI Value Based Payments -> OHI Value Based Payments Variables and Select Properties
6. Change the value of the field "Data Source Name" to match your target environment, and select OK 
7. From the Menu, select File -> Save As and save this RPD file to a known location

Deploy the RPD 

1. Navigate to your servers enterprise manager.  It should be available at http://<obiee-server>:7001/em
2. Log in as the admin user created when OBIEE was installed
3. Navigate to coreapplication -> Deployment -> Repository
4. Select lock and Edit
5. Upload the RPD, enter the password and select apply
6. Select activate changes
7. Navigate to coreapplication -> Availability
8. Select All BI Servers
9. Hit Restart Selected

Deploy the OBIEE catalog

The OBIEE catalog contains the dashboards and reports and other runtime artefacts for the VBP OBIEE installation.  As noted above, It should be located at $OHI_ROOT/reporting/OHI_Value-Based_Payments.catalog

1. Navigate to your OBIEE servers analytics home.  It should be available at http://<your-server>:9704/analytics
2. Log in as the admin user created when OBIEE was installed.
3. Select Catalog -> Shared Folders
4. Select Unarchive
5. Upload the OHI_Value-Based_Payments.catalog file
1. Use Replace: All
2. ACL: Inherit

Validate Deployment

To validate that the RPD file and the Catalogs were successfully deployed to the target OBIEE environment, execute the following steps:

1. Navigate to your OBIEE servers analytics home.  It should be available at http://<your-server>:9704/analytics
2. Log in as the admin user created when OBIEE was installed.
3. Navigate to Dashboards -> BI Overall Status Dashboard
1. The dashboard should render with no errors

Deployment of BI artefacts are complete.