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 |
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
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?
WHAT ARE THE DISTNICT VARIABLES?
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....
Define metrics studio?
What is slowely changing dimensions?why we are used SCD?
What is meant by alternate drill down with ex?
What is Normalization?
What are the services provided in cognos 8?
Can you define cognos powerplay?
where we use page break and page set. with example?
tell me two or three issues from client side and how to solve those issues?