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...


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



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

how u provide security in power play transformer???

3 Answers   iFlex, ITC Infotech, TCS,


How to perform single signon in Cognos by using URL?

3 Answers  


This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,

0 Answers  


Tell me about Schemas?

4 Answers  


What do you understand by user class in cognos?

0 Answers  


Can you define cognos impromptu?

0 Answers  


How to Reset Pagenumbers in one report.

0 Answers  


how to create cubes in transformer ?

0 Answers   IBM,


It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  


WHAT ARE THE DISTNICT VARIABLES?

0 Answers  


how u create security to reports ????

10 Answers   iFlex, iGate,


what is mean of Meta data definistions?

4 Answers   IBM,


Categories