Answer Posted / arangaraj

Hi,

All are wrong.for ex. if u have list report with
region,staff name and revenue. if u want show top 10 and
bottom 10 performance based on the revenue, drag new data
item from tool box to query item box then expression window
will show in that type like

For Top 10 performance:rank([revenue]desc for [region])
and give name for new query item like Rank or anything.
then drag this new query item to the detail filter window.
then type [Rank]<=10.

For Bottom 10 performance:rank([revenue]asc for [region])
[Rank]<=10.

if u want any query about cognos don't hesitate call me
by mobile:9787642227

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1730

---

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1539

---

What is the difference between the content store and content manager?

580

---

Explain is there any comparison available for cognos reportnet vs crystal reports?

554

---

How to Reset Pagenumbers in one report.

2228

---

---

what is stitch query in reportnet?

641

---

what is power prompt in cognos ep7series?what is the use of this?

3209

---

What is cognos powerhouse?

597

---

What is Fullouterjoin?

1560

---

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1486

---

What are all the types of gateway used in Cognos?

559

---

How to select multiple values from type-in prompt?

654

---

What are the types of studio present in Cognos?

627

---

What is the function of cognos dispatcher?

607

---

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1719

---