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

hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....

1 Answers   HCL,

how can you get the errors in job? when loops are araised we get error?

0 Answers   Syntel,

Can you define metrics designer?

0 Answers  

Can you explain dynamic query mode?

0 Answers  

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

3 Answers   Dominion,

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

0 Answers  

What is meant by Reportstudio shortcut?

0 Answers  

Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

0 Answers  

What do you mean by drill through report?

0 Answers  

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,

For more Cognos Interview Questions Click Here
Categories