This section helps you to navigate through the Metadata Browser and guides you in tracing the source of the metadata. The Metadata Browser function allows you to view and analyze all aspects of the metadata used in the OFSAAI. It provides extensive browsing capabilities of metadata, helps in tracking the impact of changes to metadata, and trace through to the source of the Originating Data.
Metadata Browser (Object and Application View) provides a common repository of Metadata Objects created in OFSAAI and applications hosted in OFSAAI. Using this view, you can identify the usage of base objects in higher-level objects and the mapping of Objects to Application, thus enabling traceability. It also allows you to view the Data Flow and the workflow of the application and understand the usage of objects within the application.
The new visualization of Metadata Browser (MDB) supports the Application View and Object View. In the Application View, you can browse through the metadata created using the applications hosted in OFSAAI. In the Object view, you can view the metadata created in OFSAAI.
To access the Metadata Browser (Object and Application View), your role must be mapped to the SCR_MDB Function.
Analysts review the metadata used for a particular report schedule to verify the data. Data Verification may require looking for metadata used in a given schedule or it can be scheduled in which particular metadata is used. Data Analysts and Reporting Analysts perform the Report Verification. Metadata refers to Business Measures, Hierarchies, Datasets, Derived Entities used for a given schedule.
To use MDB for schedule-wise metadata, and to use MDB for metadata wise schedule, identify the metadata used, perform the following steps:
1. You can verify the data for related data elements
in results using this information. Navigate to Catalog
of Objects, select OFSAA Metamodel,
select Reporting Metadata, and select
Reports.
The MDB Reporting Metadata Screen is displayed.
Figure 57: MDB - Reporting Metadata Page
2. Click the object view E2S3 to view the list of schedules. The Reporting Metadata Schedule View Page is displayed.
Figure 58: MDB - Reporting Metadata - Schedule View
You can view the following information in the Schedule Details Page:
§ Depends On: This section displays the metadata used in a given schedule.
§ Used In: This section displays the Reports in which this schedule is used.
§ Applications: This section displays the applications in which this schedule is used.
3. Click Details to view the dependency and usage information such as the Object Name and the Object Type.
Figure 59: MDB - Reporting Metadata - Schedule View 1
4. From the Schedule View Page, click the Dependency Tab to view the Report Tree Structure.
Figure 60: MDB - Reporting Metadata Tree Structure Page
Starting from common metadata used across the application, you may want to know the list of reports or Derived Entities this metadata has used. Let us take an example of a measure. To identify how value is computed, perform the following steps to trace it back to the metadata.
This section provides information on the Business Metadata Objects which include Base Metadata and Derived Metadata.
The following are the steps to perform to view the Base Metadata details. For example, Measures.
1. To view the measures, navigate to Catalog
of Objects,
select OFSAA Metamodel, select Business
Metadata, select Base Metadata,
and select Measures.
The MDB Business Metadata Page is displayed.
Figure 61: MDB - Business Metadata - Measure View Page
2. Click the Measure that you wish to view.
The MDB Business Metadata Measure Details Page is displayed.
Figure 62: MDB - Business Metadata Measure Details Page
You can view the following information on this page:
§ Measure Properties: It provides information on the properties of Business measures. For example, aggregation function, Measure Data Type, Business Exclusions, Filter, and Rollup Type.
§ It Depends On: This section displays all the object names and their types, such as Entities, Columns, and so on.
§ Used In: This section displays the Objects in which this schedule is used.
§ Applications: This section displays the applications in which this schedule is used.
3. Click Details to view the measure dependency and usage information.
Figure 63: Measure Dependency and Usage Details Page
4. From the Measure Details Page, click the Dependency tab to view the Measure Tree Structure.
Figure 64: Business Metadata Measure Tree Page
NOTE:
The similar steps as mentioned in this section are applicable for other metadata such as Business Metadata (Hierarchies, Measures, Variables, and so on) and Derived Metadata (Dimensions, Filters, and so on), Process Metadata (Process, Rules, and so on) and Data Foundation (Target Model, Sources, Connectors, and so on).
The following are the steps to perform to view the Derived Metadata details. For example, Derived Entities.
1. To view the schedule-wise derived entities, navigate to Catalog of Objects, select OFSAA Metamodel, select Business Metadata, select Derived Metadata, and select Derived Entities.
Figure 65: MDB - Business Metadata – Derived Entity Page
2. Click the Derived Entity that you wish to view.
The Derived Entity Details Page
is displayed.
Figure 66: MDB - Business Metadata Derived Entity Details Page
You can view the following information on this page:
§ Derived Entity Properties: It provides information on properties of Derived Entities, such as Source Type, Aggregate Flag, and Materialized View.
§ It Depends On: This section displays all the object names and their types, such as Dataset, Hierarchy, and so on.
§ Used In: This section displays the Objects in which this schedule is used.
§ Applications: This section displays the applications in which this schedule is used.
3. Click Details to view the Derived Entity dependency and usage information.
Figure 67: Derived Entity Dependency and Usage Page
4. From the Derived Entity Details Page, click the Dependency tab to view the Derived Entity Tree Structure.
Figure 68: Business Metadata - Derived Entity Tree Structure Page
For more information about the Metadata and its usage, see the OFSAA Metadata Browser User Guide.