How to Improve the Performance of the Report? i need this
urgently .
Answer Posted / venkat m
turn of automatic summaraize and group for tabular model
processing database it is more faster than limited local process
write simple case statemants
set sorting a field either at the tabular model level or
query level but not both
use cognos functions equivalent functions in database
use facts in the report directly donot create shortcurts for
facts under query
use page breaks instead of sectioned
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What are all the components of Report Studio?
What are the types of hierarchies?
What are the considerations regarding performance kept in mind while setting up cognos?
What is Online View?
What is the use of powerplay web viewer in cognos?
How to deploy from one server to another server?
What are the types of folder present in cognos?
-----------------What is Determination Model?
What is dtm?
How can we Maintain the Cube Security by Category level and Dimension level ?
What is the function of model design accelerator?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
how you create security to reports?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.