Skip Headers
Oracle® Communications Data Model Installation Guide
11g Release 2 (11.2)

Part Number E15887-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

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

Installing Oracle Warehouse Builder Workflow

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

  1. Go to $ORACLE_HOME/owb/wf/install

  2. Execute wfinstall.csh

    The Oracle Workflow Configuration Assistant opens.

  3. 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:

  1. Log into the Design Center of Oracle Warehouse Builder.

  2. Select File, then Import, and then Warehouse Builder Metadata.

  3. For file, specify the following value:

    $ORACLE_HOME/ocdm/pdm/relational/intra_etl/owb/OCDM_Intra_ETL.mdl
    
  4. Select Import selected objects from file, then click Select Object.

  5. Select OLAP _PFLW, then click > (Continue).

  6. Click OK.

  7. Click Import.

  8. 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:

  1. In the Design Center of Oracle Warehouse Builder, select View, and then Location Navigator.

  2. Expand Locations, then Process Flow and Schedules, then Oracle Workflow.

  3. Right click OWF_LOCATION, select Open.

  4. Edit the connection information.

  5. 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.
  1. Stop the Oracle Business Intelligence Suite Enterprise Edition Presentation services using the following command:

    BIEE_HOME/setup/run-saw.sh stop
    
  2. Start the Oracle Business Intelligence Suite Enterprise Edition Presentation Services with the following command:

    OBIEE_HOME/setup/run-saw.sh start
    
  3. 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.