Fusion OBIEE: Custom Sort order for analysis ie NOT alphabetical or numeric but according to personalized desired order such as a, c, b, e, d

(Doc ID 1994887.1)

Last updated on DECEMBER 19, 2017

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Oracle Fusion Application Toolkit - Version and later
Oracle Fusion General Ledger Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


Fusion OBIEE - need a way to obtain, (for 40+ analyses) a particular order for the list.

-The order does not follow "normal sort" such as alphabetical numeric etc .
-The order may need to be ammended as new dimensions get added, hence would need it delivered in a modular fashion, to avoid editing 40 analyses each time...

here is the example order:


Tried to create a test analysis which would create the order as I need it, then combine this with the real analyses

but when I try to combine one analysis which controls the order, with the real analysis, then each time the list is supplied as alphabetical sort


How can I specify a particular list order, which does not follow normal sort............ such as alphabetical,


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