Interested to Buy Any Domain ? << Click Here >> for more details...
what is Governor settings in cagnos?
- 5 Answers
- 33121 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Governors setting is used to reduce system resource
requirements and improve performance. You set
governors before you create packages to ensure the metadata
in 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 be
overridden by governor settings in Report Studio.
1.Report Table Limits
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
OLAP data sources.
Some queries can be very large because null values are not
filtered out. Because null suppression is
performed by the underlying data provider, in this case SAP
BW, this reduces the amount of data
transferred to the various Cognos 8 client products, thus
improving performance and returning
only relevant data in the report.
| Is This Answer Correct ? | 37 Yes | 0 No |
Answer / pnr
Governor settings means we will set some restricted data of
retrieval.
we will set for
report table limits
data retrival limits
query execution time
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / syed tauseef raza
Governor setting is basically used in Frame work Manager to
improve the performance of the reports in the way like
retrieving the number of tables or number of rows to be
displayed.These setting are done before creating the
packages to ensure the data or the information that is to
be retrieved is restricted.As well you have different types
of governor setting depending upon the data you want to
retrieve.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / arkchowdary
Governer Settings------------------
-------------- We will use for Security purpose.
Query Execution Time Limits--------------- we need to
specify the Time in this option.
Outer Joins-------------------You can control whether outer
joins can be used in your query or report.
Cross-Product Joins--------------------You can control
weather cross-product joins can be used in
your query or report.
Allow Usage of Local Cache --------------------Select this
governor to specify that all reports based on
this model should use cached data.
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.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nani
governor setting is nothing but filter in fm
using fm u can set properts
| Is This Answer Correct ? | 4 Yes | 0 No |
pls ans what are the filters we have in framework manager? filters in report studio?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
Hi all, i have a requirement in Conditional drill through. I have a list report with Cities India, UK, USA, China, japan, Canada.... In the above cities i want to give Hyperlinks(Drill) for Only India & UK. Could you please send me the steps????
can you tell me what are the dimension tables are used in project
i was asked what are the caluclations done by you in your report? plz give reply
How can we find out cardinality between two tables?
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.
cognos is holap or molap or rolap
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
what is cognos architechure
Teradata 
