1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........

Question Posted / guest

Answers were Sorted based on User's Feedback



hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls..........

Answer / annareddy

If u find the top 5 sal :
Create quires with Product type, Quantity, create Rank
column with rank(quantity)
Query1 give filter Rank<=5
Change the filter Application property from Before Auto
Aggregation to After Auto Aggregation.

Is This Answer Correct ?    2 Yes 0 No

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls..........

Answer / srini madhala

Think you have 4 dataitems in report, 1 column as salary.
So if you to find top 5 salaries then:-
rank(Sal)- Ranking Displays the ranks of the salaries based on there values.

running-cont(rank(Sal))-Top provides you the top salaries and least salaries. For example to show top5 salaries.
top<=5 display top5 salaries

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

0 Answers   IBM,

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?

0 Answers   Accenture,

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

0 Answers   iFlex,

Wt is the Diff between Business Key & member caption?

2 Answers  

I want to schedule the report as sysdate-1.....how to do

2 Answers   TCS,




What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  

15. If I select the current month and year how can we display previous 11 months data?

2 Answers   TCS,

How u provide security to reports in report studio or in cognos connection?

1 Answers   Cap Gemini,

can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..

2 Answers  

What is the difference between the standard and metrics folder?

0 Answers  

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,

What do you understand by the term 'dynamic cube'?

0 Answers  

For more Cognos Interview Questions Click Here
Categories