Oracle Business Intelligence Infrastructure Installation and Configuration Guide > NQSConfig.INI File Reference >

Oracle Dimension Export Section Parameters in the Configuration File

Oracle Database Metadata Generator is a feature that enhances the OLAP functionality of a database, allowing the database to store metadata about the logical relationships of the data residing in the database, and optimizing queries made against that database. Oracle Database Metadata Generator parses the logical layer of a repository, extracts the table sources, and converts the metadata into materialized views in the Oracle Database, which can enhance the performance of queries.

The ORA_DIM_EXPORT section of the configuration file sets the following initial values for this feature.

Oracle Database Metadata Generator functions like a metadata bridge that converts the Oracle BI proprietary metadata into a SQL format that can be used by Oracle materialized views. If you have an IBM DB2 Database, then use Oracle Business Intelligence CubeViews Generator, as described in Cube Views Section Parameters in the Configuration File.

USE_SCHEMA_NAME_FROM_RPD

The default value is YES. When set to YES, the table schema names are used as they are used in the repository.

DEFAULT_SCHEMA_NAME

This name is used as the table schema name, if either of the following is true:

• The repository schema name cannot be determined.
• The value of USE_SCHEMA_NAME_FROM_RPD is set to NO.

  Example:

  "ORACLE" ;

ORA_DIM_SCHEMA_NAME

The metadata from Oracle Database Metadata Generator is created under this schema.

Example:

"ORACLE" ;

LOGGING

Indicates whether to keep a log of the metadata export process. The default is ON; other values are OFF and DEBUG.

LOG_FILE_NAME

A valid path needs to be provided, otherwise an error is thrown.

Example:

LOG_FILE_NAME = "C:\OracleBI\server\Log\OraDimExp.Log" ;