7 Oracle Healthcare Foundation Self-Service Analytics Installation

This chapter describes how to install the OHF Self-Service Analytics:

  1. Installation Overview

  2. "Prerequisites"

  3. Install the Oracle Healthcare Foundation Self-Service Analytics

7.1 Installation Overview

OHF Self-Service Analytics (SSA) is available in the OHF_721_Linux-x64.zip file of the media pack. It is an optional component that can be installed to perform Self Service Analytics via OBIEE.

OHF SSA consists of the following components:

  • OBIEE RPD file for the Healthcare Common Data Mart, which is used for Self-Service Analytics.

  • OBIEE Catalog File with reports and dashboards built using the OBIEE RPD file for the Healthcare Common Data Mart, covering various subject areas.

  • Self-Service Analytics tool, to generate an OBIEE RPD file for data marts built based on the Healthcare Common Data Mart.

The following is the structure of the Self-Service Analytics package:

/selfserviceanalytics
    /hcd_rpd
        ohf_ssa_hcd.rpd
        obieeIds.csv
    /hcd_catalog
        Oracle Healthcare Foundation.catalog
        Oracle Healthcare Foundation Images.catalog
    /software
        ohf_ssa_tool.zip

7.2 Prerequisites

OHF Data Model must be installed. For other prerequisites, see Software Requirements.

7.3 Install the Oracle Healthcare Foundation Self-Service Analytics

To install the OHF Self-Service Analytics:

  1. Navigate to the selfserviceanalytics folder in the media pack.

  2. Open the RPD file, ohf_ssa_hcd.rpd, available in the selfserviceanalytics\hcd_rpd folder using the Oracle BI Administration Tool, and perform the following steps:

    1. Navigate to Manage > Variables, update the default value of the puser variable to point to the HCD schema name, and click OK.

    2. In the Physical layer, expand localhost and double-click Relation Connection.

      - Update the Data source name with the database host name, port number, and service name where the HCD schema is installed.

      - Update the HCD schema password and confirm.

    3. In the Physical layer, expand localhost and double-click Initialization Block Connection.

      - Update the Data source name with the database host name, port number, and service name where the HCD schema is installed.

      - Update the HCD schema password and confirm.

    4. In the Physical layer, expand OHF Data Lineage and double-click OHF Data Lineage Connection Pool.

      - Update the Data source name with the database host name, port number, and service name of the Enterprise Schema (ENT).

      - Update the ENT schema password and confirm.

  3. Save the ohf_ssa_hcd.rpd file (select No when prompted for consistency check).

  4. Deploy RPD on the OBIEE server:

    1. Create an OBIEE domain. For details, see https://docs.oracle.com/middleware/1221/core/BIEIG/GUID-4F0BD89A-C8BE-4851-8D0C-422779D5BC1D.htm#INSOA375.

    2. Navigate to the [OBIEE_HOME]/user_projects/domains/bi/bitools/bin folder.

    3. Use the datamodel.sh command line utility to upload the RPD file to the OBIEE server (look in the <OBIEE Home>/user_projects/domains/bi/bidata/service_instances directory to find the service instance name):

      ./datamodel.sh uploadrpd -I <location of rpd file to be uploaded> -W <RPDpwd> -SI <service instance name> -U <weblogic user> -P <weblogic password>

  5. Create a folder OHF_SSA_HOME in a preferred drive.

  6. Copy the ohf_ssa_tool.zip file available in the selfserviceanalytics\software folder to the OHF_SSA_HOME folder.

  7. Extract the contents of ohf_ssa_tool.zip file in the OHF_SSA_HOME folder.

    The Self-Service Analytics tool is now available in the OHF_SSA_HOME\ohf_ssa_tool folder.

For details on how to generate the OBIEE RPD using the Self-Service Analytics tool, see the Oracle Healthcare Foundation Programmer's Guide.

For details on how to set up the Usage Tracking feature, see the Oracle Healthcare Foundation Dashboards User's Guide.

7.4 Deploy the Oracle Healthcare Foundation Catalog in OBIEE

  1. Open the OBIEE Analytics Page in a Web Browser. For example:

    http://<obiee host name>:<port number>/analytics.

  2. Navigate to the Catalog menu and, under Shared Folders, click Unarchive.

  3. Specify the path to the OHF catalog file:

    <OHF Media Pack>/selfserviceanalytics/hcd_catalog/ Oracle Healthcare Foundation.catalog

  4. In the Unarchive pop-up window, select None in the Replace field and Preserve in the ACL field.

  5. Specify the path to the OHF images catalog file:

    <OHF Media Pack>/selfserviceanalytics/hcd_catalog/ Oracle Healthcare Foundation Images.catalog

  6. In the Unarchive pop-up window, select None in the Replace field and Preserve in the ACL field.

The OHF catalog is now deployed in the OBIEE shared folders location as Oracle Healthcare Foundation.

To test if the catalog has been deployed successfully, see if the Oracle Healthcare Foundation entry is available under Dashboards > My Dashboards.