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 an Oracle Communications Data Model data warehouse:

Installing and Configuring Workflow
Creating an 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 an 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 an 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 by following the instructions given in "Oracle Business Intelligence Suite Enterprise Edition".

You also need to create a catalog. For more information, see "Installing Oracle Business Intelligence Suite Enterprise Edition Catalog for Oracle Communications Data Model".

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 Analytic Workspace Manager

Although not required before you install Oracle Communications Data Model, you need to install the Analytic Workspace Manager 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/technetwork/database/options/olap/index.html

Installation instructions are included in the documentation.