16. How can we create top 10 and bottom 10 records in
the same list?
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 is difference between primary key and unique key constraints?
What is the report studio?
-----------------What is Determination Model?
What is a Pivot?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is zero-foot print?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
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)
How do you improve the performance of the Cognos Analytics report
What are the types of folder present in cognos?
What is catalog and types of catalogs in cagonos and which is better?
What is the use of Cognos scenario?
What are the two types of framework manager?
What are the types of hierarchies?