how to improve the report performance?
Answer / kumar
1) Try to use the less no. of Queries& Outer Joins.
2) If any calculation are used frequently, that need to do
at ETL level since data will be loaded with taht
Calculation.
3) avoid the Joins at Report Level.
4) Remove the unwanted Columns @ Report level.
5) Adding filters to reduce the amount of data to perform
the report well.
6) if we are using any specific filters for mutiple report
we need to create that filters at FM level as Stand alone
Filters.
7) We prefer Drill through to Master Detail Report to
reduce the time taking.
8) We prefer Conditional block to Render Variable for
Performance.
9) Use Local Cache ,If we run the any Report Frequently it
will reduce the Time.
I added My Experience points,I think few more are thare.
Thank You
Kumar
| Is This Answer Correct ? | 15 Yes | 1 No |
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
i have one file i saved in csv how can i take these file into framework manager
what is filter?give me one example that you created a report in your project?
how you migrate reports to cognos 8 from previous versions?
what do u mean by bridge group? where we r using this one?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....
what is the meaning of drill down and drill up in COGNOS 8BI
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
how to improve performance in report studio level
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?