Interested to Buy Any Domain ? << Click Here >> for more details...
16. How can we create top 10 and bottom 10 records in
the same list?
- 9 Answers
- 35910 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venu
for example if u want to create top ten employees who are
generated max revenue then add new dataitem with expression
rank(total(revenue) for employeename) and in filter
deffination dataitem<10 then u will find top ten records
and for bottom ten records add rownum to column and make
desending order nuw filter for 10 records thats it okayyyyy
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
what are slowly changing dimensions? Why we are used scd?
What is the function of model design accelerator?
What is the model filter?
Explain the difference between native sql and cognos sql?
what are the dimensions that you have in your current project?list them?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
What is the difference between set functions and filter function in dimensional data?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Give me any example of semi and non additive measures?
Why are meta service important then other services?
WHAT ARE THE DISTNICT VARIABLES?
what are the names of the reports that you prepared?
What are the advantages of using cognos sql?
----------------Diff b/w Dimensional modeling and Relational modeling?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
