Browsing Metadata Reports and Dashboard

To customize the Oracle Communications Data Model model, you must understand the dependencies among Oracle Communications Data Model components, especially how the report KPIs are mapped to the physical tables and columns. Oracle Communications Data Model provides a tool, the Metadata browser that helps you discover these dependencies. When you install Oracle Communications Data Model with its sample reports, the metadata browser is delivered as a sample Dashboard in the webcat.

See

Oracle Communications Data Model Installation Guide provides more information on installing the sample reports and deploying the Oracle Communications Data Model RPD and webcat on the Business Intelligence Suite Enterprise Edition instance.

There are four tabs (reports) in the Oracle Communications Data Model Metadata browser. To browse the metadata repository:

  1. In the browser, open the login page at http://servername:9704/analytics where servername is the server on which the webcat is installed.
  2. Login with username of ocdm, and provide the password.
  3. Select the Metadata Browser dashboard.
  4. Use the tabs in the Metadata browser to explore the metadata.
    • Measure-Entity tab

      On the Measure-Entity tab you can see the business areas (relational, OLAP, mining), the measures description, corresponding formula, responsible entities, and attributes for the measure.

    • Entity-Measure tab

      Using the Entity-Measure tab, you can discover the mappings between entities, attributes, supported measures, and calculations of the measures. You can discover information about particular entities and attributes.

    • Program-Table tab

      Using the Program-Table tab you can browse for information on the intra-ETL mappings and report information. Take the following steps:

    • Table-Program tab

      By default when you go to the Table-Program tab you see all of the tables used for all the reports.

      To discover what reports use a particular table, you must move a particular table from the right pane to the left (Selected) pane.

Using the Measure-Entity Tab Business Areas and Measures Attributes and Entities

The Measure-Entity tab provides information on the measure descriptions, computational formulas with physical columns, physical tables, and corresponding entities by Business Area.

To browse the Measure-Entity data, select the business area and measure description that you are interested in.

Using the Entity-Measure Tab Entity to Display Measures

The Entity-Measure tab displays the measures supported by the entities and how they are calculated. You can discover information about particular entities and attributes.

To view the Entity-Measure tab perform the following steps to learn more about an entity:

  1. Select the entity.
  2. Click GO.

Using the Program-Table Tab

The Program-Table tab displays the input and output tables used in the selected programs.

To use the Program-Table tab, perform the following steps to learn more about intra-ETL mappings:

  1. Select the program type (that is, intra-ETL or report) and program name for showing particular report or intra-ETL information.
  2. Select GO.

Using the Table-Program Tab to List Tables for Reports

The Table-Program tab lists the programs used by a given table and whether that table is an input or output, or both, of that program.

To discover what reports use a particular table, move a particular table from the right pane to the left (Selected) pane.

To see the reports that use a particular table, perform the following steps:

  1. In the right pane of the Table-Program tab, select the table.
  2. Move the table to the Selected list on the left by clicking on < (left arrow), and click OK.
  3. Select GO.

    The reports for the selected table are displayed.