Interested to Buy Any Domain ? << Click Here >> for more details...
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
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?
--------------Diff b/w ODS and OLAP?
What is cognos connection?
What is main advantage datawarehousing over oracle?
how to explain health care project and which reports we can create in health care doain?
What is the use of powerhouse?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
where you can save the report net documentation in our local system?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
write a query to display the departments with no employee?
What are the types of folder present in cognos?
What is a Folder?
What is the difference between a data mart and a data warehouse?
What are the components of report net?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
