Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Billing and Revenue Management Application Adapter

1 About BRM Adapter for Oracle Communications Data Model

• What Is the BRM Adapter?
• Overview of the BRM Adapter
  • Components of the BRM Adapter
• Execution Flows for BRM Adapter
  • Execution Flow Using BRM Adapter: Oracle Data Integrator-Pull Version (Without Oracle GoldenGate)
  • Execution Flow Using the BRM Adapter: with Oracle GoldenGate and Oracle Data Integrator

2 Using the BRM Adapter

• Populating Warehouse Using the BRM Adapter
  • Performing Initial Load with the BRM Adapter
  • Performing a Data Refresh with the BRM Adapter
• Verifying That Oracle GoldenGate Processes Are Running
• BRM Adapter Exception Handling
  • Exception Handler Configuration
  • Package and Step Name Mapping
  • Drop Error Tables (E$_)

3 BRM Adapter Reference

• BRM Source and Oracle Communications Data Model Target Tables
• BRM Adapter Oracle Data Integrator BRM_OCDM Project
  • Objects in SRC_STG_NONOGG Folder of BRM_OCDM Project
  • Objects in STG_OCDM Folder of BRM_OCDM
  • STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG Package
• BRM Adapter Staging Schema Objects

Part II Network Charging and Control Application Adapter

4 About NCC Adapter for Oracle Communications Data Model

• What Are Oracle Communications Prepaid Charging and Network Charging and Control
• Overview of NCC Adapter
  • Components of the NCC Adapter
• NCC Adapter Execution Flows
  • Execution Flow Using the NCC Adapter with Oracle GoldenGate and Oracle Data Integrator
  • Execution Flow Using the NCC Adapter with Only Oracle Data Integrator

5 Using the NCC Adapter

• About Populating a Warehouse Using the NCC Adapter
• Initial Loading Using the NCC Adapter
• Refreshing the Data Using the NCC Adapter
  • Refreshing the Foundation Layer on a Scheduled Basis
  • Refreshing the Foundation Layer with Real-Time Data

6 NCC Adapter Reference

• NCC Adapter Source and Target Tables
• Oracle Data Integrator NCC_OCDM Project
  • SRC_STG_NONAGG
  • STG_OCDM
• NCC_STG Schema Objects
• NCC Source Schema Objects
• Schema Definitions Added by the NCC Adapter
  • NCC_STG Schema Objects
  • Definitions Added to the ocdm_sys Schema

Part III Social Network Analytics for Oracle Communications Data Model

7 Social Network Analytics

• Overview of the Social Network Analytics Add-On Adapter
  • About Social Network Analytics Features
  • Social Network Analytics Opt-Out Features
  • Social Network Analytics Concepts and Terms
• Social Network Analytics Process Flow
• About Social Network Analytics Roles
  • Social Network Analytics Subscriber Roles Leaders and Role Strength

8 Social Network Analytics Reports

• SNA Home Page
• SNA Analysis Report
• SNA Analysis Runs Report
  • Scheduler Jobs Overview: Polling Analysis Job Report
  • Scheduler Jobs Overview: Update Analysis Job Run Log Details Report
• SNA Network Report
• SNA Communities Report
• SNA Churn Report
• SNA Influence Report
• SNA Subscribers Report

Part IV Billing Analytics for Oracle Communications Data Model

9 Billing Analytics Overview and Reports

• Overview of Oracle Communications Data Model Billing Analytics
• Overview of Billing Analytics Process Flow
• Billing Analytics Reports
  • Billed Revenue Reports
  • Billing Efficiency Reports
  • Customer Metrics Reports
  • Prepaid Metrics Reports
  • Usage Revenue Reports

10 Billing Analytics Reference

• Billing Analytics Physical Objects
• Billing Analytics Relationships and Measures
  • DWB_INVC_ITEM Analytics
  • DWD_ACCT_BAL_MO Analytics
  • DWD_ACCT_DEPT_MO Analytics
  • DWD_ACCT_PYMT_DAY Analytics
  • DWD_CNT_DAY Analytics
  • DWD_DATA_USG_DAY Analytics
  • DWD_INVC_DAY Analytics
  • DWD_PRPD_ACCT_STTSTC_DAY Analytics
  • DWD_RVN_DAY Analytics
  • DWD_TMF_KPI Analytics
  • DWD_VAS_USG_DAY Analytics
  • DWD_VOI_CALL_DAY Analytics
  • DWV_PRPD_CUST_STAT View Analytics

Part V Oracle Communications Policy and Charging Analytics

11 Policy and Charging Analytics Overview and Control

• About Oracle Communications Policy and Charging Analytics
• About Policy and Charging Analytics Intra-ETL and Oracle OLAP Control
  • Running the Intra-ETL Processes for Policy and Charging Analytics
  • Creating Scheduler Schedules
  • Creating Scheduler Jobs
  • Dropping Jobs and Schedules
  • Manually Running the Intra-ETL for Policy and Charging Analytics

12 Policy Adapter User's Guide

• Starting Policy Adapter
• Stopping Policy Adapter
• Viewing Policy Adapter Statistics
  • Viewing Policy Adapter MPE Status
  • Viewing Policy Adapter Database Statistics
• Loading Reference Data
  • Importing Device CVS File Format
  • Importing Quota CSV File Format
• Viewing Policy Adapter Alarm UI Adapter Status
• Troubleshooting Policy Adapter

13 Policy and Charging Analytics Reports

• Policy Execution Reports
  • Policy Usage: Policy Execution
  • Policy Usage: Policy Distribution Overview
  • Policy Usage: Compare by Device
  • Policy Usage: Compare by Tier
  • Policy Usage: Compare by Entitlement
• Quota Usage Reports
  • Quota Analysis
  • Usage Distribution
  • Usage Trend
  • Compare by Device
  • Compare by Entitlement
• Customer Metrics Reports
  • Customer Metrics Policy Only
  • Customer Metrics Policy and Charging

14 Policy and Charging Analytics Reference

• Policy and Charging Analytics Physical Objects
• Policy and Charging Analytics Oracle OLAP Model Dimensions
  • About the Oracle OLAP Policy and Charging Analytics Architecture
  • Policy and Charging Analytics Oracle OLAP Dimensions
• Policy and Charging Analytics Oracle OLAP Model Cubes
  • Policy Usage: POLICY_USG
  • Quota Limit: QUOTA_LMT
  • Quota Usage: QUOTA_USAGE
  • Subscriber Count: SBCRBR_CNT
  • Subscriber Count Quarter: SBCRCR_CNT_Q
  • Subscriber Count Year: SBCRCR_CNT_Y
  • Subscriber Count: SUBSCRIBER_COUNT
  • Subscriber Statistics: SUBSCRIBER_STATISTICS
• Policy and Charging Analytics Intra-ETL Packages
  • About Policy Analytic Model Intra-ETL
  • Intra-ETL PL/SQL Derived Population Packages
  • Intra-ETL PL/SQL Dimensional Population Packages
  • Operational ETL PL/SQL Packages
  • Oracle OLAP Management Packages

A TMF KPI Business Metrics

• Percentage of Payment Transactions by Payment Method (B-CE-1B)
• Percentage of Electronic Bills Issued (B-CE-1C)
• Mean Time to Prepare and Dispatch Bills (B-CE-4B)
• Percentage of Inaccurate Bills (B-CE-4C)
• Determine Percentage of Bills Adjusted (B-CE-4D)
• Percentage of Billing-Related Queries (B-CE-4E)
• Time to Prepare Bills for Display and Dispatch (B-OE-2A)
• Collections Efficiency Against Credit Terms (B-OE-3E)
• Percentage of E-payments Received (B-CE-1D)
• Percentage of Bills Adjusted Internally (B-CE-4F)
• Mean Time from Service Activation to Bill Dispatch (B_OE_2C)
• Percentage Collectible Debt Written Off (B_OE_3D)
• Volume of Customer Requests (CM_CE_3A)

Index