Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – SAMetaExport – For improving Query Performance – Precursor for Materialized Views

Posted by Venkatakrishnan J on November 5, 2007

I came across another handy utility called as the SAMetaExport. What this utility can do is, it can convert the dimensions(hierarchies) that you define in the Business Model layer of the Administration tool into actual CREATE DIMENSION script for Oracle. As you would know Dimensions in an Oracle database help in determining the Query Rewrites while using Materialized Views. You can get this utility from {OracleBI}/Server/Bin. The syntax for using this tool is as follows

SAMetaExport···-r···”<full path including the Repository Name>”···-u <username> -p <password> -f <full path of the filename containing details about the BM name etc> -t “ORACLE”

As you see above this utility requires another file as its input. This file should include the following details

BUSINESS_MODEL= “<Business Model Name>”
PHYSICAL_DATABASE =”<Physical Database Name>”
RUN_AS_USER = “Administrator”
OUTPUT_FOLDER = “D:\oracle\OracleBI\Oracle Export”

For ex:

BUSINESS_MODEL= “BISE1_TUTORIALWH”
PHYSICAL_DATABASE =”BISE1_TutorialWH”
RUN_AS_USER = “Administrator”
OUTPUT_FOLDER = “D:\oracle\OracleBI\Oracle Export”

      

      

Let us try running this utility and see the output generated. The output would be a sql file which would have the CREATE DIMENSION script.

      

      

Advertisements

One Response to “Oracle BI EE 10.1.3.3/2 – SAMetaExport – For improving Query Performance – Precursor for Materialized Views”

  1. […] sametaexport – Oracle Database Metadata Generator. See Oracle Business Intelligence Server Administration Guide and Venkat’s blog […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: