if report performance is low how can check 3 areas in
framework manager?.what are the 3 areas concentrate?

Answers were Sorted based on User's Feedback



if report performance is low how can check 3 areas in framework manager?.what are the 3 areas conc..

Answer / raji

1.Check for loops in FM..loops cause delays and wrong data
fetched from the DB.
2.Check if there is a function or filter or a view on which
the query subject is based.Remove them and add the necessary
filters or functions in the report.
3.Create indexes to frequently fetched query subjects for a
quicker access in case volume of data is large.

Is This Answer Correct ?    1 Yes 1 No

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas conc..

Answer / viswa

Check the governor settings, reduce the usage of NOT
operator & complex calculations.v

Is This Answer Correct ?    1 Yes 2 No

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas conc..

Answer / santosh kumar

If the report performance is Low
then we need to check
how many rows does it actually genarating per page..
wht's the time limit for the report...
In cognos configuration we need to reduce the load on
presentation Service..

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More Cognos Interview Questions

Which lifecycle we will use for reporting?

0 Answers  


how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  


how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..

2 Answers   Wipro,


How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,


How do add dynamic titles in PP?

3 Answers  






How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.

3 Answers  


How to create a Left Outer Join in FM? Please explain.

2 Answers   Cisco,


Can you define a catalog and types of catalogs in cognos?

0 Answers  


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,


Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 Answers  


cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  


i have one file i saved in csv how can i take these file into framework manager

0 Answers  


Categories