Answer Posted / amar
1. Use local cache property set to NO.
2. Validate expression properly.
3. Use detail filters after auto aggregation instead of summarized filters.
4. Test with limited number of data.
5. minimize sql hard code.
6. Avoid Java script usage maximum.
7. Use sql having clause expressions.
8. Avoid usage of cognos functions Maximum.
I hope this is useful...
If am wrong let me know...
Thanks
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of cognos?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What is metric store database?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is Bitmap Index?
what are the errors faced while bursting the reports and how to solve those errors?
New coloums are added in database, then how you know in report level
How can I schedule reports in cognos?
Cleared COG-112 with 100% score today. What next certification should i go for?
what is the difference between native sql and cognos sql?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
i was asked what are the caluclations done by you in your report? plz give reply
What is the complex report you faced in real time?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?