Bookshelf Home | Contents | Index | PDF |
Siebel Analytics Platform Installation and Configuration Guide > NQSConfig.INI File Reference > Cube Views Section Parameters in the Configuration FileSiebel 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_SUPPORTEDThe recommended setting and default value is NO. When set to YES, allows measure containing the "DISTINCT-COUNT" aggregation to be exported. DISTINCT_COUNT_SUPPORTED = NO ; STATISTICAL_FUNCTIONS_SUPPORTEDThe recommended setting and default value is NO. When set to YES, allows measures containing the aggregation STDDEV to be exported. USE_SCHEMA_NAMEWhen 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_RPDThe default value is YES. When set to YES, the table schema names are used as they are used in the repository. DEFAULT_SCHEMA_NAMEThis name is used as the table schema name, if either of the following is true: CUBE_VIEWS_SCHEMA_NAMEThe Cube Views metadata is created under this schema. LOG_FAILURESWhen set to YES, the log file lists the metadata that was invalidated under a certain rule. The default value is YES. LOG_SUCCESSWhen 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_NAMEA valid path needs to be provided, otherwise an error is thrown. |
Siebel Analytics Platform Installation and Configuration Guide |