Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

10. In Report studio ,how to get the top 20 employees in using list report
Row number – if only list
 Rank
 Running-count

Question Posted / malli


10. In Report studio ,how to get the top 20 employees in using list report Row number – if o..

Answer / adiubar

Open report studio >> add data item in the sequence EMP name , Emp Number , salary >> sort the salary column in descending order
Go to query explorer >> drag a data item from the toolbox >> open the data item you have created and use rank function on salary
i.e. Rank(salary)
Now add a detailed filter value [Data Item1] <= 20 and run the report .

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

What is limited local? and the uses?

2 Answers   Ness Technologies,

Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers   IBM,

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers  

What is set to be Cognos configuration?

0 Answers  

Define dimensions?

0 Answers  

How can we improve performance in framework manager level?

3 Answers   Wipro,

can we create master detail report where master and detailed container is separate?

2 Answers   JPMorgan Chase,

How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,

What is minimum version of internet explorer to run the Cognos report.

3 Answers  

Can you explain new content durability?

0 Answers  

For more Cognos Interview Questions Click Here
Categories