Oracle BI EE 10.1.3.3/2 – Metadata Reports
Posted by Venkatakrishnan J on November 21, 2007
We saw earlier here about how Catalog Reports can be created and used. In the same way we also have an option of creating Metadata Reports. Metadata Reports are those reports that shows how the Presentation Layer is related to the Business Model layer and in turn also shows how BM is related to the Physical layer. This report would give all the details like the init blocks used, variables used etc. It is a very comprehensive report that again can be very useful. Lets see how to go about creating this Report. This is available as a utility in the Administration Tool. If you open the Administration tool and go to Tool -> Utilities you would find a utility called as Repository Documentation.
As soon as you click on Execute it would ask you to save the output into a flat file. Save the report and open the report.
If you notice there are quite a few important column information that we can get out of this Report. Following are the list of columns that the report would contain.
Derived logical table
Derived logical column
Logical Table Source
Expression (BM Expression)
The above set of columns can be very useful if you quickly want to understand your metadata. Also, if need be you can use the below script to load this file into an external table
CREATE OR REPLACE DIRECTORY METADATAREPO_DIR AS ‘D:\VENKAT\ET’
CREATE TABLE METADATAREPORT_ET (
DEFAULT DIRECTORY METADATAREPO_DIR
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY 0X’09’
MISSING FIELD VALUES ARE NULL
REJECT LIMIT UNLIMITED
Once this is done, load this table back into the repository and then create a report.
Simple but very powerful.