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

• Overview of Oracle Communications Data Model
• What Are the Benefits of Using Oracle Communications Data Model?
• What Are the Components of Oracle Communications Data Model?
• What Oracle Technologies are in Oracle Communications Data Model
• What is Oracle Communications Data Model
  • About Business Areas and Subject Areas in Oracle Communications Data Model
  • About the Logical Data Model and Physical Data Model
  • About Entity Relationships in Oracle Communications Data Model
  • Understanding Named and Flexible Hierarchies
• About TM Forum Information Framework (SID) Alignment
• Business Areas in Oracle Communications Data Model

2 Logical Data Model Foundation

• Major Subject Areas and Related Entities
  • Subject Area: Account
  • Subject Area: Agreement
  • Subject Area: Billing
  • Subject Area: Business Interaction
  • Subject Area: Click Stream
  • Subject Area: Cost
  • Subject Area: Customer
  • Subject Area: Customer Field
  • Subject Area: Employee
  • Subject Area: Event
  • Subject Area: Financial GL Cost and Asset
  • Subject Area: Flexible Characteristics
  • Subject Area: Loyalty Program
  • Subject Area: Number Porting
  • Subject Area: Party
  • Subject Area: Party Partners Vendor Roaming Content
  • Subject Area: Payment
  • Subject Area: Prepaid-Balance and Voucher
  • Subject Area: Problem
  • Subject Area: Process
  • Subject Area: Product Offering and Product Subscription
  • Subject Area: Product Subscription
  • Subject Area: Product and Product Specification
  • Subject Area: Promotion and Campaign
  • Subject Area: QoS
  • Subject Area: Resource
  • Subject Area: Service and Service Specification
  • Subject Area: UDR Event
• 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 Group
  • Age On Net Band
  • ARPU Band
  • Agreement Change Initiator Type
  • Agreement Type
  • 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
  • Campaign Channel
  • Campaign Media
  • Cell Outage Reason
  • Cell Site
  • Change Proposed By Type
  • Channel
  • Collection Agency
  • Commission Type
  • Competitor
  • Contact List
  • Content
  • Content Type
  • Contract Change Initiator Type
  • Contract Assignment Reason
  • Cost Center
  • Credit Category
  • Currency
  • Customer
  • Customer Cluster
  • Customer Revenue Band
  • Customer Segment
  • Dealer
  • Debt Aging Band
  • Direct Debit Status Reason
  • Divert Retrieve Type
  • Employee
  • Environment Type
  • Event Category
  • Event Result
  • Event Type
  • External Operator
  • Fraud Profile Class
  • Geography
  • Give Away Type
  • GPRS Services
  • Handset Model
  • IN Platform
  • Initiative Type
  • Interaction Channel
  • Interaction Direction
  • Interaction Type
  • Invoice Adjustment Reason
  • Invoice Adjustment Type
  • Invoice Status
  • ISP
  • Item Subclass
  • Legal Process Status Type
  • Lifecycle Type
  • Loyalty Program Channel
  • Loyalty Tier
  • Market Area
  • Media Object Type
  • Network
  • Network Touchpoint
  • Network Touchpoint Class
  • Network Touchpoint Status
  • Network Touchpoint Type
  • Network Type
  • Notification Type
  • NP Request Type
  • On Off Net Type
  • Order Line Item State
  • Order State
  • Order Type
  • Organization
  • Packet Control Unit Outage Reason
  • Partner Settlement Reason
  • Party
  • Payment Channel
  • Payment Method Type
  • Payment Transaction Type
  • PCU Outage Reason
  • Peak Offpeak Time
  • PPA Category
  • Product
  • Product Specification Type
  • Product Subscription Status
  • Product Subscription Type
  • Promotion
  • Promotion Result Type
  • Quarter Hour
  • Reason
  • Recharge Revenue Slab
  • Redemption Type
  • Retail Type
  • RF Carrier
  • Roaming Type
  • Sales Channel
  • Sales Channel Representative
  • Script
  • Service Coverage Area
  • SKU Item
  • SPNM Other Party Number
  • Subsidy Type
  • Switch
  • Technology Type
  • Tender
  • 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
• Sequences in Oracle Communications Data Model
• 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

• About Oracle Communications Data Model Intra-ETL
• Intra-ETL PL/SQL Packages Business Rules and Source Tables
  • DWD_ACCT_BAL_MO_PKG Package
  • DWD_ACCT_DEBT_MO_PKG Package
  • DWD_ACCT_FRST_ACTVTY_PKG Package
  • DWD_ACCT_LAST_ACTVTY_PKG Package
  • DWD_ACCT_PMT_MTD_STAT_HST_PKG Package
  • DWD_ACCT_PYMT_DAY_PKG Package
  • DWD_AGRMNT_PKG Package
  • DWD_AGRMNT_CHG_PKG Package
  • DWD_AGRMNT_RVN_DAY Package
  • DWD_BER_FER_ERR_RATIO_DAY_PKG Package
  • DWD_CANBLZTN_DTL_DAY_PKG Package
  • DWD_CELL_STTSTC_DAY_PKG Package
  • DWD_CMPGN_HIST_DAY_PKG Package
  • DWD_CNT_DAY_PKG Package
  • DWD_CNTCT_CNTR_DAY_PKG Package
  • DWD_CUST_DNA_PKG Package
  • DWD_CUST_EQPMNT_INSTLTN_DAY_PKG Package
  • DWD_CUST_ORDR_DAY_PKG Package
  • DWD_CUST_ORDR_LN_ITEM_DAY_PKG Package
  • DWD_CUST_SKU_SL_RETRN_DAY_PKG Package
  • DWD_DATA_USG_DAY_PKG Package
  • DWD_GIVE_AWAY_ITEM_DAY_PKG Package
  • DWD_INV_ADJ_ITEM_DAY_PKG Package
  • DWD_INV_POSN_ITEM_DAY_PKG Package
  • DWD_INV_RCPT_ITEM_DAY_PKG Package
  • DWD_INV_UNAVL_ITEM_DAY_PKG Package
  • DWD_INV_XFER_ITEM_DAY_PKG Package
  • DWD_INVC_PKG Package
  • DWD_INVC_AGNG_DAY_PKG Package
  • DWD_NBR_PRT_DAY_PKG Package
  • DWD_POS_TNDR_FLOW_PKG Package
  • DWD_PRCS_INVC_DAY_PKG Package
  • DWD_PRPD_ACCT_STTSTC_DAY_PKG Package
  • DWD_RTL_SL_RETRN_ITEM_DAY_PKG Package
  • DWD_RVN_DAY_PKG Package
  • DWD_SPLMNTR_SRVC_USG_PKG Package
  • DWD_SRVC_PRBLM_DAY_PKG Package
  • DWD_STORE_EFFNCY_DAY_PKG Package
  • DWD_VAS_SBRP_QCK_SUMM_PKG Package
  • DWD_VAS_USG_DAY_PKG Package
  • DWD_VOI_CALL_DAY_PKG Package

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
  • Bank Direct Debit Channel: MOBJTYP
  • Billing Cycle: BCYCL
  • Churn Reason: CRNRSN
  • Collection Agency: CAGNCY
  • Commission Type: CMTYP
  • Cost Center: CCK
  • Currency: CRNCY
  • 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
  • Organization: ORG
  • Payment Channel: PCK
  • Payment Method Type: PMTYP
  • Payment Transaction Type: PTTYP
  • Peak Offpeak Time: POPT
  • Product: PROD
  • Product Offer: POFR
  • Promotion: PRMTN
  • Resource: RSCEK
  • Sales Channel: SLCHNL
  • Sales Channel Representative: SLR
  • SKU Item: SKUITEM
  • Time: TIME
  • Time Day: TIME_DAY
  • Time Slot: TSLT

9 Oracle Communications Data Model OLAP Model Cubes

• Oracle Communications Data Model OLAP Cubes
  • Account Debt Cube: ADM
  • Account Payment Cube: APM
  • Agreement Cube: AGRMNT
  • Cell Statistic Cube: CSM
  • Commission Cube: CMSN
  • Cost Organizational Cube: COM
  • Cost Product Offering Cube: CCM
  • Customer Acquisition Cube: ACM
  • Inventory Cube: INV
  • Inventory Forecast Cube: INV_FCST
  • Inventory Forecast Statistic Cube: INV_FCST_STTSTC
  • Invoice Adjustment Cube: IAM
  • Invoice Customer Type Cube: INVCM
  • Revenue Cube: RVN
  • Subscriber Churn Statistic Cube: CHRN
  • Customer Acquisition Forecast Cube: ACM_FCST
  • Customer Acquisition Forecast Statistic Cube: ACM_FCST_STTSTC
  • Cell Statistic Forecast Cube: CSM_FCST
  • Revenue Forecast Cube: RVN_FCST
  • Sales Cube: SLS
  • Sales Forecast Cube: SLS_FCST
  • Sales Forecast Statistic Cube: SLS_FCST_STTSTC

10 Oracle Communications Data Model Data Mining Models

• About Data Mining in Oracle Communications Data Model
  • Understanding the Mining Model Architecture
  • Refreshing the Oracle Communications Data Model Mining Model
• Oracle Communications Data Model Mining Result Tables
• Model 1: Prepaid Churn Prediction
  • Prepaid Churner Definition
  • Prepaid Churn Source
  • Prepaid Churn Output Target Attribute: CHRN_IND
  • Prepaid Churn Algorithm
  • Prepaid Churn Algorithm Setting Tables
• Model 2: Postpaid Churn Prediction
  • Postpaid Churner Definition
  • Postpaid Churner Source
  • Postpaid Churn Output Target Attribute: CHRN_IND
  • Postpaid Churner Algorithm
  • Postpaid Churner Algorithm Setting Tables
• Model 3: Customer Profiling
  • Customer Profiling Source
  • Customer Profile Output
  • Customer Profile Algorithm
  • Customer Profile Algorithm Setting Tables
• Model 4: Targeted Promotion
  • Targeted Promotion Source
  • Targeted Promotion Output
  • Targeted Promotion Algorithm
  • Targeted Promotion Algorithm Setting Tables
• Model 5: Customer Life Time Value
  • Customer Life Time Value Source
  • Customer Life Time Value Output Target Attribute: TOT_PYMT_RVN_LAST_MO
  • Customer Life Time Value Algorithms
  • Customer Life Time Value Algorithm Setting Tables
• Model 6: Customer Life Time Survival Value
  • Customer Life Time Value (LTV) Survival Source
  • Customer Life Time Value Survival Output Target Attribute: AGE_ON_NET_NBR
  • Customer Life Time Value Survival Algorithms
  • Customer Life Time Value Survival Algorithm Setting Tables
• Model 7: Customer Sentiment
  • Customer Sentiment Source
  • Customer Sentiment Output
  • Customer Sentiment Algorithm
  • Customer Sentiment Algorithm Setting Tables
• Oracle Communications Data Model Mining Setting Tables
• Oracle Communications Data Model Data Mining Related Tables
• Data Mining Package Customer Life Time Value Computation
  • Prepaid Customer Life Time Value Computation
  • Postpaid Customer Life Time Value Computation

11 Oracle Communications Data Model Utility Scripts

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

Part III Sample Reports

12 Oracle Communications Data Model Reports

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

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 8: Retention of Terminating Agreement
• Sample Use Case 9: Dealer and Employee Sales Commission
• Sample Use Case 10: Handling a Service Problem
• Sample Use Case 11: Implementing a Business Area

C Oracle Communications Data Model Assumptions

• Understanding General Entities
• Understanding Product Offering and Specification Entities
• Understanding Party, Party Subtypes, and Party Role
• Understanding Events and Usage Entities
  • About Business Interactions
  • About Agreements
  • About BSS/OSS Interaction Events
  • About Usage Events (UDR Events)
  • About Process Events
• Understanding Account and Agreement Entities
• Data Model and Entity Notes

D Physical Table and Logical Data Model Changes for Release 11.3.2

• Oracle Communications Data Model PDM Release 11.3.1 to Release 11.3.2
• Oracle Communications Data Model LDM Release 11.3.1 to Release 11.3.2

Index