Governor settings means we will set some restricted data of retrieval. we will set for report table limits data retrieval limits query execution time
Governor setting is nothing but filter in fmusing fm u can set properts
Governors setting is used to reduce system resource requirements and improve performance. You set governors before you create packages to ensure the metadatain the package contains the specified limits. All packages that are subsequently published will use the new settings.There are a number of governors that you can set.Governor settings in the model can beoverridden by governor settings in Report Studio.1.Report Table LimitsYou can control the number of tables that a user canretrieve in a query or report 2.Data Retrieval Limits You can control the number of rows that are returned in aquery or report 3.Query Execution Time LimitsYou can limit the time that a query can take
4.Large Text Items LimitYou can control the character length of BLOBS (binarylargeobjects) that a user can retrieve in a
You can control the number of tables that a user can retrieve in a query or report
2.Data Retrieval Limits You can control the number of rows that are returned in a query or report
3.Query Execution Time Limits You can limit the time that a query can take
4.Large Text Items Limit You can control the character length of BLOBS (binary large objects) that a user can retrieve in a query or report
5.Allow Enhanced Model Portability at Run Time You can use a separate but structurally similar data source at run time. The database schema must be the same between the two data sources.
6.Allow Usage of Local Cache Select this governor to specify that all reports based on this model should use cached data.
7.Outer Joins You can control whether outer joins can be used in your query or report.
8.Cross-Product Joins You can control whether cross-product joins can be used in your query or report.
9.Use With Clause When Generating SQL You can choose to use the With clause with Cognos SQL if your data source supports the With clause.
10.Suppress Null Values for Dimensional Data Sources This governor is supported for SAP BW data sources only. It does not work with relational or
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!