Answer / uday

1.select the list
2.drag the query items into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as.
6.in functions we have rank function(in summaries)
7.drag the rank function like rank(query item)
8.if query item is number then it will give the ranks
to that number.

Answer / gangadhar

1.select the list
2.drag the Data item1 & Data Item2 into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as----rank ([Data item1] for [Data
item2]) = 1.
6.If query item is number then it will display the ranks to
that number.

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

7 Answers   Blue Cross Blue Shield Association, TCS,

---

How can you link a query to a data container manually in Report Studio?

0 Answers  

---

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  

---

pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com

1 Answers  

---

Interval Prompt's Usage? Example for usage in Project

2 Answers   Cap Gemini,

---

---

where do we see the run time of the report ?

2 Answers  

---

Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?

4 Answers   IBM, Wipro,

---

What is difference between informatica power mart and power center?

0 Answers  

---

write a query to display to 10 max record from the employee table?

7 Answers   HCL,

---

What is snapshot thumbnail

3 Answers  

---

hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

0 Answers  

---

What is Outerjoin?

2 Answers  

---