Interview Questions   Tutorials   Discussions   Programs   

Cognos - What is Governor settings in cagnos?




512
views
asked mar September 26, 2014 01:54 PM  

What is Governor settings in cagnos?


           

1 Answers



 
answered By vishnoiprem   0  

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

flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

cognos × 1

Asked 2 years and 3 months ago ago
Number of Views -512
Number of Answers -1
Last updated
3 years and 2 months ago ago

  Similar questions


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!

Alert