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
- 35920 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / itesh
simple man
top 10 alway will be on some measure based on some dim not
simply top 10 and bottom 10,
make q1>
get the rank of the measure rank(measure for dim )<=10
make q2
the rank in the desecending order of measure
rank(measure for dim desc )<=10
make q3=q1 union q2
| Is This Answer Correct ? | 12 Yes | 1 No |
Hi,
All are wrong.for ex. if u have list report with
region,staff name and revenue. if u want show top 10 and
bottom 10 performance based on the revenue, drag new data
item from tool box to query item box then expression window
will show in that type like
For Top 10 performance:rank([revenue]desc for [region])
and give name for new query item like Rank or anything.
then drag this new query item to the detail filter window.
then type [Rank]<=10.
For Bottom 10 performance:rank([revenue]asc for [region])
[Rank]<=10.
if u want any query about cognos don't hesitate call me
by mobile:9787642227
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / suman
ex. if we have a report with 100 records then
1.select a column which has measures(ex: quantity)
2.click on calculate ,select operationtype as analytic &
operation as rank
3.select the measure col, click on sorting
4.select the measure col, click on filters(in edit data)
5.select combine filters
6.add a filterline
7.select the range as from 1 to 10
again click on add a filter & set the operation as OR &
range from 90 to 100
click ok & run
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kush
add dataitem rowcount with expression row_count.once it is
done sort the dataitem in the descending order. applying
filter with rowcount<10 gives the solution
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / barathi
hi venu can you expalin clearly with example esp for bottom
ten records
thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar / nkumar.cog@gmail.com
Hi Guys whenever posting your answers please leave you Email
ID or any contact..........Thanks
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / kruthi
By applying conditional format to the required column in
atable we can get top 10 and bottom 10 records in the same
list.
EX:if u want the employees whose sale is greater than 1000
then apply the condition employee sales>1000
then u will get the employees list whose sale is >1000 in
the top 10.
intye same way u can create bottom 10 records in the same
list
| Is This Answer Correct ? | 1 Yes | 7 No |
hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........
What is the use of report studio?
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
How to apply securities for reports in cognos connection?
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
whats the difference between previous version of cognos and cognos 8 BI?
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
How do I remove the hyperlink from the drill through report?
What is the difference between macros and prompt?
how many types of keys are there i.e primary key and foreign key etc..?
faq's on cognos
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
Teradata 
