5 Report and Query Customization

This chapter provides information about creating reports, queries, and dashboards against the data in an Oracle Communications Data Model warehouse.

  • Reporting Approaches in Oracle Communications Data Model
    Describes the two main approaches to create reports from data in an Oracle Communications Data Model warehouse: Relational Reporting and OLAP Reporting.
  • Customizing Oracle Communications Data Model Sample Reports
    Sample reports and dashboards are delivered with Oracle Communications Data Model. These sample reports illustrate the analytic capabilities provided with Oracle Communications Data Model-- including the OLAP and data mining capabilities.
  • Writing Your Own Queries and Reports
    The ocdm_sys schema defines the relational tables and views in Oracle Communications Data Model. You can use any SQL reporting tool to query and report on these tables and views.
  • Optimizing Star Queries
    A typical query in the access layer is a join between the fact table and some number of dimension tables and is often referred to as a star query. In a star query each dimension table is joined to the fact table using a primary key to foreign key join. Normally the dimension tables do not join to each other.
  • Troubleshooting Oracle Communications Data Model Report Performance
    Describes actions to identify problems when generating a report created using Oracle Business Intelligence Suite Extended Edition:
  • As Is and As Was Queries
    Describes the two common query techniques, "as is" and "as was" queries:
  • Tutorial: Creating a New Dashboard
    This tutorial explains how to create a dashboard based on the Oracle Communications Data Model webcat included with the sample Oracle Business Intelligence Suite Extended Edition reports delivered with Oracle Communications Data Model.
  • Tutorial: Creating a New Report
    This tutorial explains how to create a report based on the Oracle Communications Data Model webcat included with the sample Oracle Business Intelligence Suite Extended Edition reports delivered with Oracle Communications Data Model.