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 |
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
how to explain health care project and which reports we can create in health care doain?
Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)
Can you define query studio?
What is meant by grouped star schema
advantages of cascade prompt ???
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
How to give a securites in object level&datalevel&pakege lavel in frame work manager?
What is the advantage of using shortcuts?
Types of Performance Tuning?
i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..