Oracle® Communications Data Model

Add-Ons Release 11.3.2 Prerequisites and Installation Steps

The Oracle Communications Policy and Charging Analytics Add-on Release 11.3.2.2 requires that you first create the database instance using Bigfile tabespaces and then install Oracle Communications Data Model.

Oracle Communications Policy and Charging Analytics has installation differences compared to other Oracle Communications Data Model Add-ons. Due to these differences, the high level flow of Policy and Charging Analytics Add-on installation is as follows:

1. Make sure prerequisites are met. For more information, see Oracle Communications Data Model Adapters and Analytics Installation Guide.

2. Perform Oracle Communications Policy and Charging Analytics Add-on preinstallation steps that include installing the Oracle database and installing Oracle Communications Data Model. For more information, see Oracle Communications Data Model Installation Guide and Oracle Communications Data Model Adapters and Analytics Installation Guide.

3. Install Oracle Communications Policy and Charging Analytics Add-on. For more information, see Oracle Communications Data Model Adapters and Analytics Installation Guide.

4. Perform Oracle Communications Policy and Charging Analytics Add-on postinstallation steps. For more information, see Oracle Communications Data Model Adapters and Analytics Installation Guide.

Release 11.3.2 Issues Resolved

Add-Ons Release 11.3.2.1 Prerequisites

If the Oracle Communications Data Model Release 11.3.2 patch for bug 17863837 has not been applied, do the following:

1. Run Oracle Communications Data Model 11.3.2 patch scripts. The scripts are available for the patch associated with bug 17863837.

Source to Staging Performance Enhancement

Temporary staging layers are removed while loading data into the staging layer. Staging is not required as source to staging is 1:1 mapping. Data is directly loaded into the staging layer without putting it in temporary staging tables.

BRM_ETL_PARAMETER functionality is enhanced to filter data at the source using ODI variables. New ODI variables are introduced and are populated with BRM_ETL_PARAMETER values.

Renamed Staging to Oracle Communications Data Model Interfaces

Temporary staging to Oracle Communications Data Model interfaces are renamed in Release 11.3.2.1 to give proper names; in this release each name matches the associated target ocdm_sys tables.

New Interfaces and Remapping in Release 11.3.2.1

Table mapping is changed for several tables and new mapping is added.

Major mapping changes in Release 11.3.2.1:

1. DWR_ACCT_MAP

   The BILLINFO_T table from BRM maps to the DWR_ACCT Oracle Communications Data Model table. In the previous version DWR_ACCT was fed using the ACCOUNT_T table.

2. DWR_PROD_OFR

   The DEAL_T table from BRM maps to the DWR_PROD_OFR Oracle Communications Data Model table. In the previous version DWR_PROD_OFR was fed using the PLAN_T table.

   The PLAN_T from BRM maps to DWR_PROD_CTLG Oracle Communications Data Model table.

3. DWB_ACCT_DEBT_MAP

   A new interface is added to feed DWB_ACCT_DEBT Oracle Communications Data Model table. This mapping is used in debt related reports in Oracle Communications Data Model.

4. DWB_ACCT_BAL_MAP

   A new interface is added to feed the DWB_ACCT_BAL Oracle Communications Data Model table.

ETL Lookup Matrix Extension

A new lookup matrix mapping is added, you need to review the mapping and possibly make changes. For more information, see Oracle Communications Data Model Adapters and Analytics Installation Guide.

Introduction of BRM_GET_DD_OBJ_MAP Function

This function gives you the flexibility to configure different BRM objects for clear and understandable mapping. You need to review this mapping and you also need to make changes as required. For more information, see Oracle Communications Data Model Adapters and Analytics Installation Guide.

Exception Handling Configuration

Exception handling is added to each of the interfaces and procedures. The exception handling configuration changes enable you to skip any mappings which are not required and requires that you make configuration changes. For more information, see Oracle Communications Data Model Adapters and Analytics User's Guide.

Provided Out of Box Scenarios to Perform Data Load

Either you can make use of out of box scenarios or create custom scenarios/load plans as required.

• SRC_STG_LOAD

• STG_OCDM_LOAD

• END_TO_END_LOAD_PLAN

• END_TO_END_LOAD_PLAN__SCHEDULING

For more information, see Oracle Communications Data Model Adapters and Analytics User's Guide.

Issues Resolved

TMF SID 12 Alignment

To provide alignment with the TM Forum Information Framework (SID) Release 12, Oracle Communications Data Model Release 11.3.2 Logical Data Model (LDM), Physical Data Model (PDM), Intra-ETL, OLAP cubes, and data mining models are updated or replaced.

Data Model Extensions to Support Retail Inventory, Point of Service, and Clickstream Data

Oracle Communications Data Model has been extended to include the retail analytics of Oracle Retail Data Model to support and manage various Point of Sales. This allows Oracle Communications Data Model to analyze a Service Provider's point of sale retail items, including inventory, customer sales, and Point of Sale.

This includes the complete inventory, retail transactions, retail loyalty, customer affiliation, and so on, according to the Retail analytics.

Data Mining Model Enhancements

Oracle Communications Data Model Release 11.3.2 includes Data Mining improvements that provide:

• Improved Customer Lifetime and churn calculation taking into account user needs

• Added "Customer Life Time Value" computation programs which use "Churn Prediction" mining model output for both prepaid and postpaid customers.

• Added Prepaid Customer specific attributes. For example: Recharge and last activity.

• More Flexibility

These improvements allow Data Mining end-users to add, as needed, new attributes from the Customer DNA derived table if the default attributes are not sufficient. In addition, Customer Lifetime Value is now based on the calculation:

Number Months wanted * Monthly average margin * Retention Probability

Simplification of Core Installation and New Add-Ons Installation Type

Oracle Communications Data Model Release 11.3.1 Application Adapter Installation has changed in Release 11.3.2. Oracle Communications Data Model Release 11.3.2 uses the Add-Ons Installer (Oracle Communications Data Model Add-Ons Release 11.3.2) to install Adapters and Analytics, including BRM Adapter, NCC Adapter, Billing Analytics, and Social Network Analytics.

BRM Adapter Enhancement

Oracle Communications Data Model Release 11.3.2 BRM adapter includes the following new features:

• Re-Mapping (to renamed and reorganized tables)

• Introduction of the ETL Lookup Matrix, to allow the Intra-ETL to work as-is and to ease extensions

• Rebilling/ Corrective Billing is now supported

BRM Adapter Installation Changes

In Oracle Communications Data Model Release 11.3.2, the BRM Adapter repositories are imported from Master and Work repository dumps, rather than imported from ODI Topology. The complete installation includes two parts: the first part installs the BRM STG schema and imports the master and work repository (Oracle Communications Data Model Release 11.3.2 Add-on installer handles this par of the installation). The second part of the installation involves postinstallation manual steps as described in Oracle Communications Data Model Adapters and Analytics Installation Guide.

BRM Adapter Mapping Changes

Table 2 shows the Oracle Communications Data Model table changes for Release 11.3.1 that impact the BRM adapter mapping between BRM staging and Oracle Communications Data Model.

NCC Adapter Enhancements

Oracle Communications Data Model Release 11.3.2 NCC adapter includes new features:

• Remapping (to renamed and reorganized tables)

• Introduction of the ETL Lookup Matrix to allow the Intra-ETL to work as-is and to enable easier use of extensions.

• Rebilling and Corrective Billing is supported

NCC Adapter Installation Changes

In Oracle Communications Data Model Release 11.3.2, the NCC adapter repositories are imported from Master and Work repository dumps, rather than imported from ODI Topology. The complete installation includes two parts: the first part installs the NCC STG schema and imports the master and work repository. Oracle Communications Data Model Release 11.3.2 Add-on installer performs the first part of the installation. The second part of the installation involves postinstallation manual steps as described in Oracle Communications Data Model Adapters and Analytics Installation Guide.

NCC Adapter Mapping Changes

Table 3 shows the Oracle Communications Data Model table changes impact in Release 11.3.2 for the NCC Adapter mapping between NCC staging and Oracle Communications Data Model.

Support for Oracle Communications Social Network Analytics

Oracle Communications Data Model provides the Social Network Analytics (SNA) Add-On that is optimized for social network analysis across large volumes of Call Data Record data (CDR) associated with an Oracle Communications Data Model data warehouse.

Social Network Analytics features include:

• Identification of social network communities.

• Network metrics characterizing the social graph.

• Network distribution information.

• Predictive scores for churn and influence at a node level, and potential revenue or value at risk.

• User interface targeted at business users and flexible ad-hoc reporting, including the ability to setup and configure or execute an analysis at a specific time at scheduled intervals.

You can use Oracle Communications Data Model Social Network Analytics and the associated reports and tools to assist you with:

• Acquiring customers

• Retaining customers

• Growing your customer base

Support for Oracle Communications Billing Analytics

Oracle Communications Data Model Release 11.3.2 with the Billing Analytics option provides additional Billing Analytics. The Billing Analytics reports are derived from the Oracle Communications Data Model tables which are populated with the BRM Adapter and the NCC Adapter.

Billing Analytics features include:

• End-to-end analytic application developed on Oracle Communications Data Model

• Leverages data fed through the BRM Adapter and the NCC Adapter

• Provides comprehensive dashboards built with Oracle Business Intelligence Suite Enterprise Edition 11g.

• Enables users to:

  • Understand existing business customers across all their products and services

  • Predict and analyze customer behavior to increase revenue and retention

• Reduces time, cost, risk, and complexity of a custom solution

Billing Analytics reports are available as an option with Oracle Communications Data Model Release 11.3.2 Add-Ons. Billing Analytics reports are broadly classified into the following areas:

RPD Warning Messages

A number of warning messages appear in the RPD included in Oracle Communications Data Model. The warning messages do not impact any of the out-of-the-box reports included with Oracle Communications Data Model.

Deinstall Warning Message Can Be Ignored

Bug 13601107 deinstall warning error in the deinstall log file

The following warning message, or messages similar to the following message can be ignored on deinstall:

WARNING: Error while copying directory
//dbhome_1/inventory with exclude file list
 '/tmp/OraInstall2012-01-11_02-37-25PM/installExcludeFile.lst' to nodes


. /logs/installActions2012-01-11_02-37-25PM.log'

. for details. You may fix the errors on the required remote nodes
Refer to the install guide for error recovery.
This deinstallation was successful
End of deinstallations

Fully Configured Oracle Communications Data Model Requires More Space than Reported by Oracle Installer

When installing Oracle Communications Data Model, the Oracle Installer reports only the amount of space required for copying the Oracle Communications Data Model files (that is, 240MB).

However, a fully-installed and configured Oracle Communications Data Model also requires space for the Database files created during the postinstall configuration of Oracle Communications Data Model.

If insufficient space is available for the Oracle Communications Data Model Database files, the Oracle Communications Data Model installation fails during configuration.

This issue is documented in bug 13243223.

Workaround

Before installing and configuring Oracle Communications Data Model, ensure that at least 3 GB is available.

Installer Error Message is Wrong and is not Translated

When installing Oracle Communications Data Model, the Oracle Installer reports an error message similar to the following when a wrong path is specified in the Specify Home Details dialog:

OUI-10137-An oracle Home with name Oradb11g_home1 already exists at location
/scratch/aaa/sw Please specify another name for oracle home 

This error message should read as follows:

Oracle Communications Data Model can only be installed into one existing ORACLE database 11gr2 Oracle Home.
Choose an existing oracle database 11gr2 oracle home for installing this
software
 

This issue is documented in bug 10128575.

Workaround

There is no workaround for this issue.

Installer Help Text Includes Extra Characters for Select Install Type Dialog Translation Issue

When installing Oracle Communications Data Model, the Oracle Installer includes extra help text in the help associated with the Select Install Type dialog. The dialog shows some extra characters.

This issue is documented in bug 10128520.

Workaround

There is no workaround for this issue.

Installer Help Text Not Translated

When installing Oracle Communications Data Model for a language other than English, the Oracle Installer includes English help text in the help associated with the Select Install Type dialog. The following dialogs are not translated: Specify Oracle Communications Data Model Schema Information, Specify Calendar Date Range, Specify Partitions for Reference and Base Tables.

This issue is documented in bug 10128517.

Workaround

There is no workaround for this issue.

Add-Ons Installer Installs a Single Component

The Oracle Communications Data Model Add-Ons installer supports installing one component at a time.

Workaround

To install multiple Oracle Communications Data Model Adapters or Analytics components, run the Add-Ons installer once for each component you want to install.

OCDM CONFIGURATION ASSISTANT FAILED DURING SAMPLE REPORTS INSTALLATION

This issue can occur in an Oracle RAC environment depending on whether the internal Oracle OLAP cube structure build work is assigned to other nodes in parallel. If the work is assigned to other nodes, you may see this issue.

This issue is documented in bug 18557960.

Workaround

Install Oracle Communications Data Model sample on a single instance.

OCDM:INTRA-ETL ACTIVITY CREATE_LTV_GLMR_MODEL COMPLETED WITH ERRORS

This issue is deferred.

This issue is documented in bug 18556496.

Workaround

To ensure the mining model creation succeeds run a specific data update directly to the DWD_CUST_DNA table (derived table direct update instead of update and population using Intra ETL program) at an appropriate time.

> UPDATE DWD_CUST_DNA

> SET TOT_PYMT_RVN_LAST_MO = ROUND(DBMS_RANDOM.VALUE(500,6000))

> WHERE DAY_KEY = 20110201> ;

> commit;

This can be done only after activity "DWD_CUST_DNA" (To Populate Table => DWD_CUST_DNA) is successful as before that the table is empty. Also this update needs to be done before activity "create_ltv_glmr_model" (To Populate Table => create_ltv_glmr_model).

GOT STUCK IN AIX.PPC64 PLATFORM ONLY WHILE CREATING ANALYTIC WORKSPACE

This issue is documented in bug 18598969.

Workaround

There is no workaround for this issue.