Answer / sharath.dwh

AGGREGATE FUNCTIONS ARE USED AT DETAIL LEVEL(ROW LEVEL)

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



SHARATH

My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.

1 Answers  

---

Are you aware of any limitations in Cognos?

1 Answers   HCL,

---

3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?

3 Answers   CTD, Wipro,

---

What is the difference between filter & Condition?

3 Answers   MetLife, TCS,

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---

-------------How you design DWH?

0 Answers   Bank Of America,

---

can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,

---

What is the use of powerhouse?

0 Answers  

---

what is textsource variable

2 Answers   HCL,

---

what are the errors faced while bursting the reports and how to solve those errors?

0 Answers   EDS,

---

What is value prompt limitations while creating report? What is select and search prompt?

1 Answers  

---

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

---