How to improve the performance of the report at the report
level?
Answers were Sorted based on User's Feedback
Answer / venkat
Remove the unwanted joins and filters
and complex calculations we will do the all calculations in
the item level in Framework manager level
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gopal
These are some properties to improve the performance
Apply
filters
Sorting
Grouping
if u have more than one Query set query execution Method = Concurrent in properties Pane of query explore.
and Query processing options -Date base and limited Local.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gauri
There are various things and they differ based on the case we are looking at.
Master detail relations defined on reports, having multiple singleton objects, poorly joined facts, in some cases having too many render variables also cause issues.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you define cube?
What is difference between informatica power mart and power center?
Which service handles requests for cognos connection,query studio and event studio.
hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........
If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in
Why is auto-regression used in forecasting used on cognos platform?
Where do you set security levels for users in reports?
What is Conditional block? How do you use in a report?
Why do we create shortcuts in framework manager
what do u mean by bridge group? where we r using this one?
In framework Manager, what is a stitch query and is it good or bad?
how u will design the report if the objects are available