Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the report performance?
- 1 Answers
- 6225 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 |
What is the deployment requirements used in cognos?
is cognos 7 is better than cognos 8
How to apply securities for reports in cognos connection?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
what is the security module used in cognos?
difference between join and union in reportstudio?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what are versions of cognos from starting release to latest in the market?
What are the differences between Cognos 8 and Cognos 7.x version?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
In how many ways we can apply the security to a cube in Transformer? Explain?
Explain what is the difference between native sql and cognos sql?
Teradata 
