4 Installation of Additional Components

This chapter describes how to install Oracle components that you did not need to install before you installed the Oracle Healthcare Data Model component or sample reports, but that you will use when you are creating an Oracle Healthcare Data Model data warehouse:

Creating an Oracle Business Intelligence Suite Enterprise Edition Catalog
Installing Analytic Workspace Manager

Creating an Oracle Business Intelligence Suite Enterprise Edition Catalog

The sample reports provided with the Oracle Healthcare Data Model are created using the Oracle Business Intelligence Suite Enterprise Edition. In order to modify these reports or to use them as the basis for creating new reports you must have installed Oracle Business Intelligence Suite Enterprise Edition and have created an Oracle Business Intelligence Suite Enterprise Edition catalog for the Oracle Healthcare Data Model.

Installing Oracle Business Intelligence Suite Enterprise Edition

If you installed Oracle Healthcare Data Model sample reports, you installed Oracle Business Intelligence Suite Enterprise Edition as a pre-installation step before you ran the installer. If you installed the Oracle Healthcare Data Model component rather than the sample reports, then install Oracle Business Intelligence Suite Enterprise Edition at this time by following the instructions given in "Oracle Business Intelligence Suite Enterprise Edition".

Tip:

To check that Oracle Business Intelligence Suite Enterprise Edition is installed, follow the instructions in "Confirming that Oracle Business Intelligence Suite Enterprise Edition is Installed".

Installing a Catalog for Oracle Healthcare Data Model

Once Oracle Business Intelligence Suite Enterprise Edition is installed, follow these steps to install an Oracle Business Intelligence Suite Enterprise Edition catalog for the Oracle Healthcare Data Model:

Tip:

In these directions, replace BIEE_HOME with the name of the directory where Oracle Business Intelligence Suite Enterprise Edition is installed, and replace BIEE_DATA_HOME with the name of the directory where Oracle Business Intelligence Suite Enterprise Edition data is stored.

Stop the Oracle Business Intelligence Suite Enterprise Edition Presentation services using the following command:
```
BIEE_HOME/setup/run-saw.sh stop
```
Start the Oracle Business Intelligence Suite Enterprise Edition Presentation Services with the following command:
```
OBIEE_HOME/setup/run-saw.sh start
```
Add a definition for ohdm_db for the Oracle Healthcare Data Model repository to use when connecting to the database. Add this definition to the file $ORACLE_HOME/network/admin/tnsnames.ora:
```
ohdm_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domain)(PORT = port-number))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID) # Change your SID, Hostname, and Listener PortNumber
)
)
```
Tip:
Be careful to split these commands properly when you add them to the file; for example, do not add them as one long concatenated line of code.

Note:
If you want to use another database name, you must change the tnsname in the Oracle Business Intelligence Suite Enterprise Edition repository. See the Oracle Business Intelligence Suite Enterprise Edition documentation for directions for defining a database connection in repository.

Installing Analytic Workspace Manager

Although not required before you install Oracle Healthcare Data Model, you need to install the Analytic Workspace Manager in order to view and modify Oracle Healthcare Data Model OLAP cubes. Analytic Workspace Manager 11g is installed as a standalone product. The latest version of Analytic Workspace Manager is available at the Oracle OLAP home page at http://www.oracle.com/technology/products/bi/olap/olap.html. Installation instructions are included in the documentation.