Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Logical and Physical Data Model

1 Introducing Oracle Communications Data Model

• What is Oracle Communications Data Model?
• What Are the Benefits of Using Oracle Communications Data Model?
• What Are the Components of Oracle Communications Data Model?
• Oracle Communications Data Model Concepts
  • Business Areas and Subject Areas in Oracle Communications Data Model
  • Logical Data Model and Physical Data Model in Oracle Communications Data Model
  • Entity Relationships in Oracle Communications Data Model
  • Named and Flexible Hierarchies
• Oracle Products That Make Up Oracle Communications Data Model
• TM Forum Information Framework (SID) Conformance

2 Logical Data Model Foundation

• Major Subject Areas and Related Entities
  • Subject Area: Account Simple
  • Subject Area: Customer
  • Subject Area: Dealer
  • Subject Area: Geography
  • Subject Area: Organization Business Unit
  • Subject Area: Party
  • Subject Area: Party (Extended)
  • Subject Area: Product
  • Subject Area: Product Instance
  • Subject Area: Service
  • Subject Area: Subscription
  • Subject Area: Time Calendar
  • Subject Area: Vendor
  • Subject Area: Wireless Network
• Logical Entities for Business Areas
  • Business Area: Cost
  • Business Area: Customer Management
  • Business Area: Marketing
  • Business Area: Network
  • Business Area: Partner Management
  • Business Area: Product Management
  • Business Area: Provisioning and Service
  • Business Area: Revenue
• Logical Data Model Entity Dictionary

3 Logical Data Model Dimensions

• Logical Data Model Dimensions
  • Access Method
  • Account
  • Account Payment Method Status Type
  • Account Refund Reason
  • Address Location
  • Age Band
  • Age On Net Band
  • ARPU Band
  • Bank Direct Debit Channel
  • Ber Fer Type
  • Billing Cycle
  • Billing Status Type
  • Business Time
  • Calendar Time
  • Call Category
  • Call Center Agent
  • Call Center Case Title
  • Call Center
  • Call Direction
  • Call Other Type
  • Call Routing Type
  • Call Service Type
  • Call Source Destination
  • Call Success Fail Type
  • Call Type
  • Campaign Channel
  • Campaign
  • Cell Outage Reason
  • Change Proposed By Type
  • Collection Agency
  • Commission Type
  • Content Type
  • Contract Change Initiator Type
  • Contract Assignment Reason
  • Contract
  • Credit Category
  • Customer Revenue Band
  • Customer Segment
  • Dealer
  • Debt Aging Band
  • Direct Debit Status Reason
  • Divert Retrieve Type
  • Employee
  • Event Result
  • Event Type
  • External Operator
  • Fraud Profile Class
  • Geography
  • Give Away Type
  • GPRS Services
  • Handset Model
  • IN Platform
  • Initiative Type
  • Interaction Channel
  • Internet Service Provider
  • Invoice Adjustment Reason
  • Invoice Adjustment Type
  • Item
  • Legal Process Status Type
  • Loyalty Program Channel
  • Market Area
  • Network
  • Network Element
  • Network Touchpoint Class
  • Network Touchpoint Status
  • Network Touchpoint Type
  • Notification Type
  • NP Request Type
  • On Off Net
  • Organization
  • Partner Settlement Reason
  • Party
  • Payment Channel
  • Payment Method Type
  • Payment Transaction Type
  • PCU Outage Reason
  • Peak Offpeak Time
  • PPA Category
  • Product
  • Product Market Plan
  • Promotion
  • Promotion Result Type
  • Recharge Revenue Slab
  • Redemption Type
  • RF Carrier
  • Roaming Type
  • Sales Channel
  • Sales Channel Representative
  • Service Coverage Area
  • Subscription
  • Subsidy Type
  • Switch
  • Technology Type
  • Time Slot
  • UMS Access Type
  • Value Added Services (VAS)

4 Oracle Communications Data Model Physical Data Model

• Introduction to Oracle Communications Data Model Physical Data Model
• Reference Tables
• Lookup Tables
• Base Tables
• Derived Tables
• Aggregate Tables
• Temporary and Other Tables
• Database Sequences
• Compressed Tables
• Oracle Communications Data Model OLAP Cube MV, Cube View

5 Oracle Communications Data Model Logical to Physical Mapping

• Overview of Mapping and Inheritance in Oracle Communications Data Model
• Logical to Physical Mappings for Oracle Communications Data Model

6 Oracle Communications Data Model Partitioning

• About Oracle Communications Data Model Partitioning, Compression, and Parallelism
• Partitioning Strategy for Oracle Communications Data Model

Part II Intra-ETL, OLAP, Data Mining, and Utility Scripts

7 Oracle Communications Data Model Intra-ETL

• Introduction to Oracle Communications Data Model Intra-ETL
• Value Lookup Models for ETL Mappings
• Intra-ETL Source and Target Tables
  • DWD_ACCT_DEBT_DAY_PKG Package
  • DWD_ACCT_PYMT_DAY_PKG Package
  • DWD_ACCT_PYMT_MTHD_STAT_HIST_PKG Package
  • DWD_ACCT_RFND_DAY_PKG Package
  • DWD_ACCT_STAT_PKG Package
  • DWD_ARPU_BASE_PKG Package
  • DWD_CALL_CNTR_CALL_DAY_PKG Package
  • DWD_CALL_CNTR_CASE_DAY_PKG Package
  • DWD_CANBLZTN_DTL_DAY_PKG Package
  • DWD_CMISN_DAY_PKG Package
  • DWD_CNCT_DSCNCT_DAY_PKG Package
  • DWD_CNRT_PKG Package
  • DWD_CNRT_CHNG_PKG Package
  • DWD_COST_CUST_PKG Package
  • DWD_COST_ORG_PKG Package
  • DWD_CRDT_CTGRY_PKG Package
  • DWD_CUST_ACQSTN_SUMM_DAY_PKG Package
  • DWD_EXTRNL_DEBT_COLLCTN_DAY_PKG Package
  • DWD_GIVE_AWAY_ITEM_DAY_PKG Package
  • DWD_INTRNL_DEBT_COLLCTN_DAY_PKG Package
  • DWD_INVC_PKG Package
  • DWD_INVC_ADJ_PKG Package
  • DWD_LYLTY_PROG_DAY_PKG Package
  • DWD_MKT_OPRTR_PRTNG_PKG Package
  • DWD_PRPD_ACCT_STTSTC_PKG Package
  • DWD_PRPD_ALWNCE_DAY_PKG Package
  • DWD_PYMT_AGNG_DAY_PKG Package
  • DWD_RDMPTN_DAY_PKG Package
  • DWD_SHOP_EFFNCY_DAY_PKG Package
  • DWD_SL_DAY_PKG Package
  • DWD_SL_RPRSTV_STTSTC_MO_PKG Package
  • DWD_SPLMNTR_SRVC_USG_MAP Mapping
  • DWD_VAS_SBRP_QCK_SUMM_PKG Package
• Intra-ETL PL/SQL Mapping Packages for Source and Target Tables
  • DWD_DATA_USG_DAY_PKG Package
  • DWD_VAS_USG_DAY_PKG Package
  • DWD_VOI_CALL_DAY_PKG Package
• Intra-ETL Process Flows
  • Details of the DRVD_FLW Intra-ETL Flow
  • Details of the AGGR_FLW Intra-ETL Flow
  • Details of the OLAP_MAP Intra-ETL Flow
  • Details of the MINING_FLW Intra-ETL Flow

8 Oracle Communications Data Model OLAP Model Dimensions

• Introduction to OLAP Architecture
  • General Process to Populate the OLAP Module in Oracle Communications Data Model
  • Query Rewrite to Cube Organized Materialized Views
• Oracle Communications Data Model OLAP Dimensions
  • Account Refund Reason: ARRSN
  • Churn Reason: CRNRSN
  • Collection Agency: CAGNCY
  • Commission Type: CMTYP
  • Customer: CUST
  • Customer Segment: CSGMNT
  • Customer Type: CUSTYP
  • Debt Aging Band: DAB
  • Geography: GEO
  • Handset Model: HSMDL
  • Invoice Adjustment Reason: IARSN
  • Invoice Adjustment Type: IATYP
  • Mining Churn Type: MNCT
  • Mining Life Time Survival Band: MNLSB
  • Mining Life Time Value Band: MNLVB
  • Mining Sentiment Category: MNSC
  • Network Element: NELMNT
  • Organization: ORG
  • Payment Channel: PCHNL
  • Payment Method Type: PMTYP
  • Payment Transaction Type: PTTYP
  • Peak Offpeak Time: POPT
  • Product: PROD
  • Product Market Plan: PMP
  • Promotion: PRMTN
  • Sales Channel: SLCHNL
  • Time: TIME
  • Time Slot: TSLT

9 Oracle Communications Data Model OLAP Model Cubes

• Oracle Communications Data Model OLAP Cubes
  • Account Debt Cube
  • Account Payment Cube
  • Account Refund Cube
  • Cell Statistic Cube
  • Commission Cube
  • Contract Cube
  • Cost Organizational Cube
  • Cost Product Market Plan Cube
  • Customer Acquisition Cube
  • External Debt Collection Cube
  • Handset Stock Cube
  • Invoice Adjustment Cube
  • Invoice Customer Type Cube
  • Revenue Cube
  • Subscriber Churn Statistic Cube
  • Customer Acquisition Forecast Cube
  • Customer Acquisition Forecast Statistic Cube
  • Cell Statistic Forecast Cube
  • Handset Stock Forecast Cube
  • Revenue Forecast Cube

10 Oracle Communications Data Model Data Mining Models

• About Data Mining in Oracle Communications Data Model
  • Understanding the Mining Model Schema and Architecture
  • Using the Mining Model Refresh Procedure
• Oracle Communications Data Model Mining Result Tables
• Model 1: Churn Prediction
  • Churn Prediction Churner Definition
  • Churn Prediction Source
  • Churn Prediction Output
  • Churn Prediction Algorithm
• Model 2: Customer Profiling
  • Customer Profiling Source
  • Customer Profiling Output
  • Customer Profiling: Algorithm
• Model 3: Customer Churn Factor
  • Customer Churn Factor Source
  • Customer Churn Factor Output
  • Customer Churn Factor Algorithm
• Model 4: Cross-Sell Opportunity
  • Cross-Sell Opportunity Source
  • Cross-Sell Opportunity Output
  • Cross-Sell Model Algorithm
• Model 5: Customer Sentiment Detection
  • Customer Sentiment Detection Source
  • Customer Sentiment Detection Output
  • Customer Sentiment Detection Algorithms
• Model 6: Life Time Value (LTV) Prediction
  • Life Time Value (LTV) Prediction Source
  • Life Time Value (LTV) Prediction Output
  • Life Time Value (LTV) Prediction Algorithm

11 Oracle Communications Data Model Utility Scripts

• Calendar Population
  • Calendar Population Scripts
  • How to Populate Calendar Data

Part III Sample Reports and Adapters

12 Oracle Communications Data Model Sample Reports

• Cost and Contribution Sample Reports
  • Operational Finance Analysis
  • Profitability Analysis
• Customer Management Sample Reports
  • Customer Acquisition
  • Customer Growth Rate
  • Customer Segmentation
  • Customer Life Time Value
  • Customer Churn Analysis
  • Customer Churn Prediction
• Marketing Sample Reports
  • Targeted Promotion Lift and List
  • Customer Market Share Analysis
  • Current Customer Base Analysis
• Network Sample Reports
  • Network Analysis
  • Network Health Analysis
  • Network Usage
• Partner Management Sample Reports
  • Roaming Partner Settlement
  • Churn Outliner by Partner
  • Partner Content Sales
  • External Debt Collection
• Product Management Sample Reports
  • Product Management
  • Average Profit Per Customer
• Provisioning and Activation Sample Reports
  • Activations and Services
  • Customer Order Analysis
• Revenue Sample Reports
  • Revenue Analysis and Forecast
  • Revenue Assurance
  • Sales Analysis
  • Debt Collection
  • Refund and Adjustment
  • Customer Contracts

13 Oracle Communications Data Model NCC Application Adapter

• Oracle Communication Prepaid Charging and Network Charging and Control Overview
• Network Charging and Control Application Adapter Architecture Overview
• NCC Adapter to Oracle Communications Data Model ETL Table Mapping

14 Oracle Communications Data Model BRM Application Adapter

• BRM Adapter for Oracle Communications Data Model
• BRM Adapter Architecture Overview
• BRM Adapter to Oracle Communications Data Model Table Mapping

Part IV Appendices

A Control Tables

• Intra-ETL Load Parameters Control Table
• Intra-ETL OLAP Mapping Control Table
• Intra-ETL Monitoring Process Control Tables

B Oracle Communications Data Model Business Use Case

• Sample Use Case: Introduction
• Sample Use Case 1: Setting Up the Business Unit Organization
• Sample Use Case 2: Acquiring a New Customer (with Family Plan)
• Sample Use Case 3: Service Implementation
• Sample Use Case 4: Storing Customer Call Data
• Sample Use Case 5: Customer Billing
• Sample Use Case 6: Changing Plan and Billing Address
• Sample Use Case 7: Targeted Promotion for Video-on-Demand Services
• Sample Use Case 9: Retention of Terminating Contract
• Sample Use Case 10: Dealer and Employee Sales Commission
• Sample Use Case 11: Handling a Network Fault
• Sample Use Case 12: Implementing a Business Area

Index