Answer / sharath.dwh

AGGREGATE FUNCTIONS ARE USED AT DETAIL LEVEL(ROW LEVEL)

AND ROLLUP AGGREGATE IS USED AT SUMMARY LEVEL(GROUP LEVEL).



SHARATH

HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

4 Answers   IBM, TCS,

---

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

0 Answers   Bank Of America,

---

wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers  

---

Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?

1 Answers  

---

how to improve performance in report studio level

1 Answers   Wipro,

---

What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,

---

What is the difference between drill down and drill through?

10 Answers   DELL, Deloitte, Systime,

---

what are the dimensions that you have in your current project?list them?

0 Answers   IBM,

---

How can create users and permissions in cognos?

0 Answers  

---

What is Fullouterjoin?

0 Answers  

---

If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in

2 Answers   HCL,

---

Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  

---