Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the report performance?
- 1 Answers
- 6079 Views
- I also Faced
- E-Mail Answers
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 |
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?
what is the difference between native sql and cognos sql?
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
what is the difference between group and association?
What is slowely changing dimensions?why we are used SCD?
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
------------------- What is Busschema?
What is the difference between Open Connection command ang Open Session Command?
What is Dynamic Grouping? what is diff between grouping n levelspan?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
Teradata 
