Answer / 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.

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

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.

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.

Answer / nani

governor setting is nothing but filter in fm

using fm u can set properts

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

16 Answers  

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

0 Answers  

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

0 Answers  

1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?

1 Answers  

16. How can we create top 10 and bottom 10 records in the same list?

9 Answers   TCS,

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

What is the use of report studio?

0 Answers  

Is it possible to apply access manager user rights in impromptu?

1 Answers  

---------------Tell me about DWH Concepts?

0 Answers   Bank Of America,

how can i provide security to my reports in report studio?

3 Answers   TCS,

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

1 Answers   HCL,