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

Cube Views Section Parameters in the Configuration File

Oracle Business Intelligence CubeViews 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. The CubeViews Generator parses the logical layer of a repository, extracts the table sources, and converts the metadata into Cube Models for DB2 DBMS.

NOTE:  The term IBM DB2 Cube Views is a registered trademark of IBM.

The Cube Views optimizer generates scripts to create Materialized Query Tables (MQT), which can enhance the performance of queries. The CubeViews Generator functions like a metadata bridge that converts the Oracle BI proprietary metadata into an XML format that can be used by IBM DB2 Cube Views.

If you have an Oracle Database, then use Oracle Database Metadata Generator, as described in Oracle Dimension Export Section Parameters in the Configuration File.

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

DISTINCT_COUNT_SUPPORTED

The recommended setting and default value is NO. When set to YES, allows measure containing the DISTINCT_COUNT aggregation to be exported.

Example:

DISTINCT_COUNT_SUPPORTED = NO ;

STATISTICAL_FUNCTIONS_SUPPORTED

The recommended setting and default value is NO. When set to YES, allows measures containing the aggregation STDDEV to be exported.

USE_SCHEMA_NAME

The default value is YES.

When set to YES, the Cube Views metadata attributes has columns from tables under a schema name, which are then specified in the parameters . When set to NO, the schema names for these tables are empty.

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" ;

CUBE_VIEWS_SCHEMA_NAME

The Cube Views metadata is created under this schema.

Example:

"ORACLE" ;

LOG_FAILURES

When set to YES, the log file lists the metadata that was invalidated under a certain rule. The default value is YES.

LOG_SUCCESS

When set to YES, the log file lists the metadata which has checked under each rule and has passed the check. The default value is NO.

LOG_FILE_NAME

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

Example:

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