10. In Report studio ,how to get the top 20 employees in using list report
Row number – if only list
Rank
Running-count
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 |
tell me the creation of Snapshots?
What are the different types of OLAP. Which one is Cognos Powercube?
faq's on cognos
How can we Maintain the Cube Security by Category level and Dimension level ?
what is a Galaxy Schema?
How can we migrate from Businees Objects reports to Cognos 8.x??
What is content store?
What is the use of Generated Prompt? Where is it used in realtime project?
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
What are the considerations regarding performance kept in mind while setting up cognos?
What is an olap designer?
What are initial page components of Cognos connection?