OLAP Models

OCDM leverages the following OLAP 11g features of the Oracle database:

  • Time series intelligence (across multiple time hierarchies)
  • Ranking and share calculations
  • Forecasting
  • What-if analysis
  • Compressed cubes
  • Cube MVs

OLAP Models Leverage Multidimensional Calculation Engine

Oracle OLAP's world-class multidimensional calculation engine is inside the database, where the data is consolidated. OLAP provides excellent query performance for ad hoc and unpredictable queries, regardless of the level of aggregation.

OCDM OLAP models enable analysis of:

  • Network Usage
    • By Time, Geography (Cell)
    • By Call Category, source, destination
    • Drill up/down
  • Billing and Collections
    • ROCE, ARPU, EBITD, ARPE Reports
    • Revenue Forecast
    • Collected/Uncollected
    • Debt Ageing
  • Churn Summary
    • Termination by Shop, Branch, Agent
    • Churn Profile & Attributes
    • Churn factor Importance
    • Recharging Behavior
    • Switching Trends
  • Revenue Assurance
    • UDR Revenue vs Billed Revenue
    • Incoming/Outgoing Revenue MoU, RPU and Blended Rates
    • Contract Sum of future Plans
    • Monthly Plan Drop outs
  • Sales & Service
    • Net/Gross Sales Report
    • Sales Growth Analysis
    • Product Performance
    • Marketing Plan Performance
    • Sales Forecast
    • Commissions by Sales Channel
    • Premium Redemption Choice
    • Amortized Contract Sale

OLAP Cubes

The following list contains some of the OLAP cubes associated with the OCDM OLAP models:

  • Customer related cubes:
    • Acquisition Forecast
    • Acquisition Forecast Statistic
    • Cost By Customer Type
    • Invoice Customer Type Aggregated
  • Account related cubes:
    • Account Debt
    • Account Payment
    • Account Refund
    • Subscriber Churn Statistic
    • Contract Aggregated By Month
  • Organization related cubes
    • Commission Aggregated By Month
    • Cost By Organization
  • Product (Equipment) related cubes
    • Cell Statistic
    • Cell Statistic Forecast
    • Handset Stock Aggregated By Month
    • Handset Stock Forecast
  • Sales related cubes
    • Invoice Adjustment Aggregated By Month
    • Revenue Forecast
    • External Debt Collect

OLAP Reports

Predefined OCDM OLAP reports provide:

  • Forecasts based on historical data (examples include Revenue Forecast and Out-of-Stock Forecast reports)
  • Time series analysis (as found in the Sales Growth Anaysis report). Time series calculations will work on any measure to deliver YTD, % Change from Year Ago, Prior Period, and many other comparative metrics.
  • Ranking and Share analysis
  • What-if analysis

 

Close Window