How to apply shorting on Water fall report in OBIEE 12 C

user652652 · Sep 19, 2017 11:00AM

Hi Experts,

We have report like below:

Dim1 measure1 seq

union

Dim2 measure2 seq

union

Dim3 measure3 seq

where in seq we are giving values like 1,2,3 etc. and shorting working fine on Seq in case of table/pivot view . But in Waterfall view its, shorting automatically on Dim1 values.We tried with result column shorting also,but no luck.

Please suggest,How we can apply shorting in waterfall based on Seq.

or any other suggestion pls.

Thanks,

Gianni Ceresa · Sep 19, 2017 11:15AM

Hi,

Assuming you talk of "sorting" instead of "short selling" (shorting Meaning in the Cambridge English Dictionary ).

Which exact version of OBIEE 12c ?

Looks good in mine as long as the sorting column is placed before the "Dim 1/2/3" column.

user652652 · Sep 19, 2017 1:32PM

Thanks Gianni,

We are using 12.2.1.2.0.

i placed it before dim ,but no luck

user652652 · Sep 19, 2017 1:34PM

we do have group by and measure area, where you want me to put sorting column.?

user652652 · Sep 20, 2017 8:54AM

any suggestion pls

Gianni Ceresa · Sep 20, 2017 9:10AM

12.2.1.3 : work as expected

(sample using 3 UNION, normal order would by "BizTech", "FunPod", "HomeView")

The sorting column has values defined by hand for each query (10, 20, 30), adding it before the "Brand" the sorting is based on this column instead of "Brand", if I then make it hidden it will not be visible but still force the sorting.

So you probably have an issue somewhere as it's the standard behaviour ...

user652652 · Sep 21, 2017 9:02AM

Thanks a lot,

Its done.

Gianni Ceresa · Sep 21, 2017 9:43AM

So can you please close the thread?

Right now it's still This question is Not Answered.

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

How to apply shorting on Water fall report in OBIEE 12 C

Answers