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 the advantage of using shortcuts?
What are the advantages of using cognos sql?
how you provide security to reports? How you provide security to packages ?
How can create users and permissions in cognos?
Write some methods to apply securities in framework manager model?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What DB View and Bus View?
Mention the difference between ‘macros’ and ‘prompt’?
What do you understand by the term 'model durability'?
What is Additive function?
Why is auto-regression used in forecasting used on cognos platform?
What errors and types of errors you faced in Cognos ReportNet?
What is zero-foot print?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is the size of the cube?
