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.

hi friends pls forward impropmtu interview question

2110

---

-----------Diff b/w OLAP and RDBMS?

2031

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4200

---

What is the difference between set functions and filter function in dimensional data?

2889

---

what are the features in cognos8ui

2024

---

Can you define cube?

1005

---

How to publish a package by running Java Script?

2069

---

Give me any example of semi and non additive measures?

955

---

What are the advantages of cognos?

969

---

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

1885

---

how to create measures and dimensions?

1066

---

----------------Diff b/w Dimensional modeling and Relational modeling?

14967

---

Define datastores in cognos?

936

---

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2357

---

What do you understand by ‘ibm predictive maintenance and quality’?

975

---