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
How the Bursting happens in same report and how to Print the bursting Report?
What is Bitmap Index?
How to publish a package by running Java Script?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
WHAT ARE THE DISTNICT VARIABLES?
What are all the types of indexes in Cognos?
Define the cognos reporting tool?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What do you understand by the term 'aggregate cache'?
What are the roles defined by cognos platform?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
can we insert all types of charts in a list report? what r the realtime prompts?
-----------------What is Determination Model?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
