10/11

5 Installing EHA Self-Service Analytics

The EHA Self-Service Analytics tool is available in the rpd_generator folder in the media pack. You must install and run this tool from a Microsoft Windows machine.

This chapter describes how to install EHA Self-Service Analytics securely. It contains the following sections:

• Section 5.1, "Prerequisites"

• Section 5.2, "EHA Self-Service Analytics Installation Overview"

• Section 5.3, "Application Toolkit EHA Self-Service Analytics Installation"

5.1 Prerequisites

Following are the prerequisites for EHA Self-Service Analytics:

• Java Runtime Environment (JRE) 1.8 (64-bit)

• Oracle Business Intelligence Developer Client Tools 11.1.1.7.0

• OHADI 3.0 or 3.1 Application Toolkit Data Mart (HCD star schema). Follow the instructions in Oracle Healthcare Analytics Data Integration 3.0 Application Toolkit Secure Installation and Configuration Guide.

5.2 EHA Self-Service Analytics Installation Overview

The EHA Self-Service Analytics is supported on Microsoft Windows 64-bit OS.

The following is the media pack folder structure:

MEDIA_PACK_LOCATION

/application_toolkit

/rpd_generator

/hcd_rpd

/software

/dbscripts

MEDIA_PACK_LOCATION refers to the location of the OHADI 3.1 media pack.

5.3 Application Toolkit EHA Self-Service Analytics Installation

The EHA Self-Service Analytics tool is available in the rpd_generator/software folder in the media pack. You must install and run this tool from a Microsoft Windows machine.

Perform the following installation steps:

1. Create a folder OHADIAT_SSA_HOME in a preferred drive.

2. Go to the application_toolkit\rpd_generator\software folder in the media pack.

3. Unzip the ohadi_3.1_at_rpd.zip file to the <drive:>\OHADIAT_SSA_HOME\ folder. The tool is available in the <drive>\OHADIAT_SSA_HOME\ohadi_3.1_at_rpd\ folder.

If OHADI 3.0 HCD Data mart is used, perform the following steps:

1. Log in to Oracle 11g database as HCD user.

2. Execute the following script available in the \application_toolkit\rpd_generator\dbscripts folder:

   ohadi31_at_hcd_master_installer_sec.sql

3. If the Application Tookit ETL component is installed, perform the following steps:

   1. Execute the following script, which is available in the \application_toolkit\rpd_generator\dbscripts folder in the HCD schema:

      HCD_PLOADW_DAY_D.sql

   2. Reload the Day Dimension by executing the Day Dimension ETL available in the HCD_INITIAL_ LOAD folder.

For details on generating the OBIEE RPD using the EHA Self-Service Analytics tool, see Oracle® Healthcare Analytics Data Integration Application Toolkit Programmer's Guide for EHA Self-Service Analytics.