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?
• New Features in Oracle Communications Data Model
• What Are the Benefits of Using Oracle Communications Data Model?
• What Are the Components of Oracle Communications Data Model?
• Oracle Products That Make Up Oracle Communications Data Model
• TM Forum Information Framework (SID) Conformance

2 Logical Data Model Foundation

• Major Area Reference Entities
  • Account Simple Entity
  • Customer Entity
  • Dealer Entity
  • Geography Entity
  • Organization Business Unit Entity
  • Party Entity
  • Party Subject Area Entity
  • Product Entity
  • Product Instance Entity
  • Service Entity
  • Subscription Entity
  • Time Calendar Entity
  • Vendor Entity
  • Wireless Network Entity
• Business Area Logical Entities
  • Cost Business Area Logical Entity
  • Customer Management Business Area Logical Entity
  • Marketing Business Area Logical Entity
  • Network Business Area Logical Entity
  • Partner Management Business Area Logical Entity
  • Product Management Business Area Logical Entity
  • Provisioning and Service Business Area Logical Entity
  • Revenue Business Area Logical Entity
• 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 Change 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
  • 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
• Partition Definitions
• Oracle Communications Data Model OLAP Cube MV, Cube View

5 Oracle Communications Data Model Logical to Physical Mapping

• Logical to Physical Mappings for Oracle Communications Data Model

6 Oracle Communications Data Model Partitioning

• Partitioning Strategy for Oracle Communications Data Model

Part II Inter-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 Oracle Warehouse Builder Mapping Source and Target Tables
  • DWD_ACCT_DEBT_DAY__MAP Mapping
  • DWD_ACCT_PYMT_DAY__MAP Mapping
  • DWD_ACCT_PYMT_MTHD_STAT_HIST__MAP Mapping
  • DWD_ACCT_RFND_DAY__MAP Mapping
  • DWD_ACCT_STAT__MAP Mapping
  • DWD_ACCT_STTSTC__MAP Mapping
  • DWD_ARPU_BASE__MAP Mapping
  • DWD_CALL_CNTR_CALL_DAY__MAP Mapping
  • DWD_CALL_CNTR_CASE_DAY__MAP Mapping
  • DWD_CANBLZTN_DTL_DAY__MAP Mapping
  • DWD_CMISN_DAY__MAP Mapping
  • DWD_CNCT_DSCNCT_DAY__MAP Mapping
  • DWD_CNRT__MAP Mapping
  • DWD_CNRT_CHNG__MAP Mapping
  • DWD_COST_CUST__MAP Mapping
  • DWD_COST_ORG__Map Mapping
  • DWD_CRDT_CTGRY__MAP Mapping
  • DWD_CUST_ACQSTN_SUMM_DAY__MAP Mapping
  • DWD_CUST_DEBT_COLLCTN__MAP Mapping
  • DWD_EXTRNL_DEBT_COLLCTN_DAY__MAP Mapping
  • DWD_GIVE_AWAY_ITEM_DAY__MAP Mapping
  • DWD_HNDST_SUBSDY_DAY__MAP Mapping
  • DWD_INTRNL_DEBT_COLLCTN_DAY__MAP Mapping
  • DWD_INVC__MAP Mapping
  • DWD_INVC_ADJ__MAP Mapping
  • DWD_LN_ACTVTN_TMNT_DAY__MAP Mapping
  • DWD_LYLTY_PROG_DAY__MAP Mapping
  • DWD_MKT_SHARE__MAP Mapping
  • DWD_MKT_OPRTR_PRTNG__MAP Mapping
  • DWD_PRPD_ACCT_STTSTC__MAP Mapping
  • DWD_PRPD_ALWNCE_DAY__MAP Mapping
  • DWD_PRPD_CALL_SUMM_DAY__MAP Mapping
  • DWD_PYMT_AGNG_DAY__MAP Mapping
  • DWD_RDMPTN_DAY__MAP Mapping
  • DWD_SBCRBR_CHRN_STTSTC__MAP Mapping
  • DWD_SHOP_EFFNCY_DAY__MAP Mapping
  • DWD_SHRD_PKG_USG_STTSTC_DAY__MAP Mapping
  • DWD_SL_DAY__MAP ETL Mapping
  • DWD_SL_RPRSTV_STTSTC_MO__MAP Mapping
  • DWD_SPLMNTR_SRVC_USG_MAP Mapping
  • DWD_SUBSDY_AMT__MAP Mapping
  • DWD_VAS_SBRP_QCK_SUMM__MAP Mapping
• Intra-ETL PL/SQL Mapping Source and Target Tables
  • DWD_DATA_USG_DAY Mapping
  • DWD_VAS_USG_DAY Mapping
  • DWD_VOI_CALL_DAY Mapping
• Intra-ETL Process Flows
  • Details of the DRVD_FLW Intra-ETL Flow
  • Details of the AGGR_FLW Intra-ETL Flow
  • Details of the OLAP_FLW Intra-ETL Flow
  • Details of the MINING_FLW Intra-ETL Flow
• Executing the Intra-ETL

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 Customer Cube
  • Cost Organizational Cube
  • Customer Acquisition Cube
  • Customer Mining Statistics 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
• Metadata Population
  • Metadata Population Pre-Requisites
  • Metadata Population Steps

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 Future Life Time Value
  • Customer Churn Analysis
  • Customer Churn Prediction
• Marketing Sample Reports
  • Targeted Promotion
  • 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
• Provisioning and Service 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

Part III 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: SuperTelco Business Unit Organization
• Sample Use Case 2: Setting Up the Business Unit Organization
• Sample Use Case 3: Acquiring a New Customer (with Family Plan)
• Sample Use Case 4: Service Implementation
• Sample Use Case 5: Storing Customer Call Data
• Sample Use Case 6: Customer Billing
• Sample Use Case 7: Changing Plan and Billing Address
• Sample Use Case 8: 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