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 |
How to a create header dynamically in a crosstab report in cognos 8.1?
How to select all in value prompt instead of cascade prompt?
What is difference between drill through and drill down?
What are the types of studio present in Cognos?
what is surrogate key give example?
Difference between Express authoring mode and Professional authoring mode?
What is Index?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
What is meant by alternate drill down with ex?
what is requery in cognos?
How to create model and how to test model?