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 SEPTEMBER 21, 2016

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
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