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 |
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
What is the difference between macro & Parameter
advantages of cascade prompt ???
can we put more measure on cross tab? If so how many? How this affect the aggregation?
How can you create prompts in framework manager?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Why cognos scenario is used?
can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What you mean by drill across?
How applying "Level Span" in Cognos 8.3?