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
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What is a Datastore in Cognos?
What is the difference between a data mart and a data warehouse?
What are shortcuts? Where it can be used? What are the advantages?
Write some methods to apply securities in framework manager model?
What is the size of the cube?
What are the components of report net?
-----------------What is Direct and Conventional loading?
What are the types of security?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What is meant by alternate drill down with ex?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
Can you define query studio?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance