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 u provide security in power play transformer???
3 Answers iFlex, ITC Infotech, TCS,
How to perform single signon in Cognos by using URL?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
Tell me about Schemas?
What do you understand by user class in cognos?
Can you define cognos impromptu?
How to Reset Pagenumbers in one report.
how to create cubes in transformer ?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
WHAT ARE THE DISTNICT VARIABLES?
how u create security to reports ????
what is mean of Meta data definistions?