Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
what is hints in cognos and where we use it.
whats the difference between previous version of cognos and cognos 8 BI?
What are all the types of report?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
How create measures and demensions?
What is catalog and types of catalogs in cagonos and which is better?
What is called Cognos powerplay?
What you mean by drill across and what is the difference between drill through, drill across?
What do you understand by the term 'model durability'?
What is the difference between the standard and metrics folder?
What is defined as data mining?
Define query items?
Can you define metrics designer?
how u will design the report if the objects are available
Why need staging area database for dwh?
