Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issue with Topn or Rank

user12863665Dec 17 2016 — edited Mar 22 2017

Hi, i have same value for most of the rows for different dimension rows.in this case when i apply number 5 for RANK or topN, its returning more than 5 rows because measure values are same for all rows. anyone suggest me how can i get only first 5 rows(based on Asc order for dimension) even though values are same?
This post has been answered by Uma Mahesh on Dec 17 2016
Jump to Answer

Comments

Uma Mahesh
Answer

I have one alternative solution for this

1. set sort order for measure column (I'm Applying Descending order)

2. create another measure column like   BOTTOMN(RSUM(Measurecolumn),5)

3.if you are using Ascending order then use TOPN instead of BottomN

Marked as Answer by user12863665 · Sep 27 2020
Joel Acha

You must have a set of dimension attribute which makes each row unique in order for your ranking to work. As you mentioned, your report appears to be returning the same values for several rows so you'll need to distinguish each row.

If you could send across a screenshot then you might get some specific recommendations about what your next steps should be.

Sent from my iPhone

1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2017
Added on Dec 17 2016
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
519 views