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 |
What are the types of hierarchies?
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.
What is the importance of Dimension in the cognos.
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
Which lifecycle we will use for reporting?
what type of charts we create mostly in realtime? plz help
What is difference between drill through and drill down?
What are the different types of important services used in cognos?
what is reprompt?
What is value prompt limitations while creating report? What is select and search prompt?
How to configure the Cognos configurations to work in the Windows 2000 Server machine?