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 |
How do we implement Check Box Prompt in COgnos Report Studio?
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
set scope level in transformer
what is the difference between aggregation and roll up aggregation?
what type of charts we create mostly in realtime? plz help
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem
Explain the Difference Between Bursting and Scheduling?
What is slowely changing dimensions?why we are used SCD?
what is logs in cognos
what is a prompt value in report studio and variables ?
what is cognos architechure