Siebel Analytics Platform Installation and Configuration Guide > NQSConfig.INI File Reference >

Cube Views Section Parameters in the Configuration File

Siebel Analytics 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. The Cube Views optimizer generates scripts to create Materialized Query Tables (MQT), which can enhance the performance of queries.

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

The CubeViews Generator functions like a metadata bridge that converts the Siebel Analytics proprietary metadata into an XML format that can be used by IBM DB2 Cube Views.

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

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:

  "SIEBEL" ;

CUBE_VIEWS_SCHEMA_NAME

The Cube Views metadata is created under this schema.

Example:

"SIEBEL" ;

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:

"C:\SiebelAnalytics\Log\CubeViews.Log" ;