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
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 |
Answer / viswa
Check the governor settings, reduce the usage of NOT
operator & complex calculations.v
| Is This Answer Correct ? | 1 Yes | 2 No |
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 |
if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............
Hi,Can anyone tell me training centre for cognos in Mumbai?
what is mean by complex starschema ,star schemagrouping?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?
What is meant by grouped star schema
how u publish the packages in framework manager
How to select all in value prompt instead of cascade prompt?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
What are shortcuts? Where it can be used? What are the advantages?
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.
any difference between cognos and real time cognos