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 Communications Data Model component or sample reports, but that you will use when you are creating a Oracle Communications Data Model data warehouse:

Installing and Configuring Workflow
Creating a Oracle Business Intelligence Suite Enterprise Edition Catalog
Installing Analytic Workspace Manager

Installing and Configuring Workflow

There are two ways to execute the Oracle Communications Data Model intra-ETL:

Without using Oracle Warehouse Builder Workflow. In this case, you execute the following file:
```
$Oracle_Home/ocdm/pdm/relational/intra_etl/owb_exec/ ocdm_execute_wf.sh 
```
In this case, you do not need to install and configure Workflow as explained in this topic.
Using Oracle Warehouse Builder Workflow. The Intra-ETL provided in Oracle Communications Data Model that populates your Oracle Communications Data Model data warehouse uses a process flow designed using the Oracle Warehouse Builder Workflow component.

In this case, before you can execute that intra-ETL you must perform the following tasks:
1. Install Oracle Warehouse Builder Workflow, as described in "Installing Oracle Warehouse Builder Workflow".
2. Import the Oracle Communications Data Model intra-ETL into Workflow, as described in "Importing Oracle Communications Data Model Intra-ETL into Workflow".
3. Configure Oracle Warehouse Builder Workflow to work with Oracle Communications Data Model, as described in "Configuring Oracle Warehouse Builder Workflow".

Installing Oracle Warehouse Builder Workflow

To install Oracle Warehouse Builder workflow, take the following steps:

Go to $ORACLE_HOME/owb/wf/install
Execute wfinstall.csh

The Oracle Workflow Configuration Assistant opens.
Enter values for the Workflow account, Workflow, SYS password, and TNS Connect Descriptor.

For TNS Connect Descriptor, use the following syntax where you replace local-host, port-number, and service-name with the appropriate values.
```
(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=local-host)(PORT = port-number))) (CONNECT_DATA = (SERVICE_NAME = service-name))
```
Click Submit.

Importing Oracle Communications Data Model Intra-ETL into Workflow

To import the Oracle Communications Data Model intra-ETL into Workflow, take the following steps:

Log into the Design Center of Oracle Warehouse Builder.
Select File, then Import, and then Warehouse Builder Metadata.

For file, specify the following value:

$ORACLE_HOME/ocdm/pdm/relational/intra_etl/owb/OCDM_Intra_ETL.mdl

Select Import selected objects from file, then click Select Object.
Select OLAP _PFLW, then click > (Continue).
Click OK.
Click Import.
After the import, you can see OLAP_PFLW under OCDM_INTRA_ETL project of Oracle Workflow.

Configuring Oracle Warehouse Builder Workflow

To configure Oracle Warehouse Builder workflow to work with Oracle Communications Data Model, take the following steps:

In the Design Center of Oracle Warehouse Builder, select View, and then Location Navigator.
Expand Locations, then Process Flow and Schedules, then Oracle Workflow.
Right click OWF_LOCATION, select Open.
Edit the connection information.
Click Test Connection to test the connection; if successful, click OK.

Creating a Oracle Business Intelligence Suite Enterprise Edition Catalog

The sample reports provided with Oracle Communications 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 a Oracle Business Intelligence Suite Enterprise Edition catalog for Oracle Communications Data Model.

Installing Oracle Business Intelligence Suite Enterprise Edition

If you installed Oracle Communications 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 Communications 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 Communications 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 Oracle Communications 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 ocdm_db for the Oracle Communications Data Model repository to use when connecting to the database. Add this definition to the file $ORACLE_HOME/network/admin/tnsnames.ora:
```
ocdm_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 Communications Data Model, you need to install the Analytic Workspace Manager in order to view and modify Oracle Communications 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.