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

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

0 Answers  


i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

4 Answers   Tech Mahindra,


WHAT ARE THE DISTNICT VARIABLES?

0 Answers  


It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 Answers  


Define metrics studio?

0 Answers  


What is slowely changing dimensions?why we are used SCD?

2 Answers  


What is meant by alternate drill down with ex?

0 Answers  


What is Normalization?

3 Answers  


What are the services provided in cognos 8?

0 Answers  


Can you define cognos powerplay?

0 Answers  


where we use page break  and page set. with example?

1 Answers   CNSI, IBM,


tell me two or three issues from client side and how to solve those issues?

0 Answers   TCS,


Categories