Answer Posted / ramachandra

Hi,

You may get solution by using data item,here i can the procedure how to do it..
Step 1; drag required year, month,revenue to the report page
Step 2: pause on query explorer select query1 then drag data item into data items(it displays expression box) write condtion like "running-total ([revenue])" then test it press ok.Rename it as Total.
Step 3: then drag total(dataitem) to report page.
Step:then run the report .

-Ramu

What is Metrics designer?

1027

---

What is meant by junk dimension?

1183

---

What are all the advantages of Cognos?

1037

---

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

2017

---

Define query studio?

1003

---

How create measures and dimensions?

1076

---

What are the types of folder present in cognos?

1097

---

Can you define framework manager?

1030

---

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2101

---

What is meant by alternate drill down with ex?

1089

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2573

---

What is looping and how to avoid it in framework manager?

1206

---

What is main difference mapplets and mapping?

1193

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

2199

---

Explain informatica architecture?

997

---