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 |
what are determinants?
4 Answers College School Exams Tests, IBM,
what is a prompt value in report studio and variables ?
What is Model Versioning or Versioning in Cognos Framework Manager?
how can i test the reports in cognos
What is called a slice?
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.
What is a Folder?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
What is the difference b/w macros and prompt?
What is meant by Tabular SQL in Cognos Report net
What are the advantages of cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com