BI: How to implement 2 level Ranking

(Doc ID 2308600.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Analytics

Customer wanted to implement 2 level Ranking as below:

Example

----------

Level 1) Get the Top 150 Accounts based on a custom column value

Leave 2) Get the Last updated Activity for each of those 150 Accounts

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms