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.
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:
servernameis the server on which the webcat is installed.
ocdm, and provide the password.
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.
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.
Using the Program-Table tab you can browse for information on the intra-ETL mappings and report information. Take the following steps:
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.
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.
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:
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:
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:
The reports for the selected table are displayed.