Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
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 |
Post New Answer View All Answers
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is the difference between Open Connection command ang Open Session Command?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is cognos reporting tool?
What is looping and how to avoid it in framework manager?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is called Cognos powerplay?
Why are meta service important then other services?
What is drill down and slicing and dicing whats the difference between them?
Can you define cognos impromptu?
How to apply securities for reports in cognos connection?
---------------Tell me about DWH Concepts?
What is the difference between ‘macro’ and ‘prompt?
