Setting Up Oracle Incentive Compensation Analytics for ODI

This appendix covers the following topics:

Prerequisites

The following applications must be installed in the system, before you work with Oracle Incentive Compensation Analytics:

Setting Up OIC Metadata Components

The ODI artifacts and OBIEE metadata repository are bundled with the 7631642:R12.CN.B patch. These components are installed and deployed in E-Business Top, in the $CN_TOP/patch/115/odi and $CN_TOP/patch/115/obiee directories respectively.

Creating DBLINK

On the target instance/schema, create a database link ORACLE_APPS with the connection details of the source instance/schema.

CREATE DATABASE LINK ORACLE_APPS
CONNECT TO APPS
IDENTIFIED BY &AppsPassword
USING ‘(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = &HostName) (PORT = &PortNo)) (CONNECT_DATA = (SID = &DBName)))’;

Setting Up ODI

Setting up ODI consists of:

ODI Topology

Logical Schema Tab

  1. Create the logical schema “ORACLE_APPS” for source schema

  2. Create the logical schema “ORACLE_CN” for target schema

Context Tab

Create the context “CN_CONTEXT”

Physical Schema

Define the Source Schema and Target Schema data servers.

  1. Create the Data Server “ORACLE_CN_OLTP” for source schema.

    If the source and target schemas are defined in the same instance then enter “ORACLE_APPS” in Instance/dblink (Data Server).

    If the source and target schemas are defined on separate instances, then name Instance/dblink (Data Server) as db/SID/TWO_TASK.

  2. Associate CN_CONTEXT with ORACLE_APPS, under the Context tab.

  3. Create the data server “ORACLE_CN_OLAP” for target schema. Name the Instance/dblink as TWO_TASK name.

  4. Associate CN_CONTEXT with ORACLE_CN, under the context tab.

ODI Designer

Bundle and copy all the ODI artifacts files to a location accessible by ODI. To import Oracle Incentive Compensation ODI artifacts:

  1. Locate the Import Util file, cnodi_import_util.zip, in the $CN_TOP/odi/US/util/ folder; copy it to the ODI installation/staging area and unzip into a temporary folder.

  2. Locate the ODI installation folder bin folder.

  3. Modify odiparams.sh on Linux) or odiparams.bat on Windows) according to the ODI setup, including jdbc connections and repository info.

    For example,

    set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
set ODI_SECU_URL=jdbc:oracle:thin:@localhost:1521:XE
set ODI_SECU_USER=snpm1 set ODI_SECU_ENCODED_PASS=ccfHMPvDjDxVJ.ODIXD2kUkRte
set ODI_SECU_WORK_REP=WORKREP1 set ODI_USER=SUPERVISOR
set ODI_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH

  4. Modify properties in odi_import.properties under the util folder.

  5. 5. Run the following command in ODI installation bin folder, specifying the Buildfile location and the name of the output log file:

    On Windows:

    D:\Oracle_ODI\oracledi\bin>startcmd OdiAnt "- 
BUILDFILE=D:\OIC\ODI\packaging\UTIL\build.xml" "- 
LOGFILE=D:\OIC\ODI\packaging\UTIL\output.log"

    On Linux:

    sh startcmd.sh OdiAnt "-
BUILDFILE=/slot/ems3512/oracle/OICANA/util/build.xml" "-
LOGFILE=/slot/ems3512/oracle/OICANA/util/output.log"

Re-Host ODI Invocation in E-Business Suite

  1. Deploy odi-sdk-invocation.jar on EBS Apache installation Ensure that the CLASSPATH has reference to jdk/bin and jdbc/lib/ojdbc14.jar.

  2. Include odi-sdk-invocation.jar into the environment variable $AF_CLASSPATH

Re-host the ODI Scenario parameter file.

For E-Business Suite Application concurrent manager to initiate the ELT process:

  1. Unzip the cnodiparams.zip file located in the $CN_TOP/patch/115/odi/US/util/ folder into the APPLCSF area. Update the cn_odiparams.properties file with the ODI connection parameters.

  2. Start he ODI agent.

Setting Up OBIEE

  1. 1. Re-Host the Oracle Incentive Compensation Analytics metadata files.

    1. Unzip the $CN_TOP/patch/115/obiee/cnrpd.zip file under the <Oracle BI Home>/server/Repository directory.

    2. Unzip the $CN_TOP/patch/115/obiee/cnwebcat.zip file under the <Oracle BI Data Home>/web/catalog directory.

  2. Shutdown the OBIEE services

  3. Modify the OBIEE Repository server configuration file.

  4. For single-sign on from EBS Application to the BI Reports, modify the OBIEE Web Catalog configuration file for external authentication.

    Note: Refer My Oracle Support note 552735.1.

  5. Set up the connection pool.

  6. Start the OBIEE service.

Setting Up Users and Access

Add users to the EBS application and assign responsibilities to these users.

The Compensation Manager should have access to the following dashboard pages and reports:

The Plan Administrator should have access to all the dashboard pages that the Compensation Manager has access to, and the following Scenarios reports:

The Sales Manager should have access to the following dashboard and reports: