10. In Report studio ,how to get the top 20 employees in using list report
Row number – if only list
Rank
Running-count
Answer Posted / 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 View All Answers
What do you understand by the term 'aggregate advisor?'
What is the metric store database?
What is the difference between regular dimension and derminant?
What is difference between content store and content manager?
What are types of batch available in cognos?
Can you define report item?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What are the types of security?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is defined as Cognos Impromptu?
Can you define transformer?
i was asked what are the caluclations done by you in your report? plz give reply
please please give me some banking calculations in framework manager.
What is zero-foot print?