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 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Goal

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:

ww
a3
au
hk
id..
etc

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

00
be
fr
us...

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

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