COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: skanthb on 10 Dec 2009 01:46:14 AM

Title: materialized views and Framework Manager xmin( ) functions
Post by: skanthb on 10 Dec 2009 01:46:14 AM
Framework Manager SQL xmin( ) Model Governors
Cognos strongly endorses the use of materialized views for optimum performance. However, the default generation of SQL xmin( ) functions for attributes disables the use of materialized views and can result in problems. Two configuration flags exist already to stop the xmin( ) generation in the case of determinants and levels.
You can now use two configuration options in Framework Manager as model governors to drive the xmin( ) generation for both levels and determinants.
If the governor is missing, RQP (Relational Query Planner) will read the value of the corresponding CQE configuration flag from their configuration file and use it instead.
------------------------------------------

can someome shed more light on this? detailed explanation on how to resolve this plssssssss?