Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pivot Table Sorting Issue

Saptarshi BiswasOct 26 2017 — edited Oct 26 2017

Hi All.

We are in the process of migrating from 11g to 12c (12.2.1.2.0 (Build BIPS-20160923092103 64-bit)).

One of the issues we came across in 12c is pivot table sorting does not behave the same way as in 11g. It does not seem to be a new feature.

Please see the figures below-

11g 12c

==== ====

pastedImage_6.png pastedImage_5.png

So, in 11g you can see the values are sorted the way they should be, descending order on the second column (201610) Whereas, in 12c, same query, once column is (201610) sorted in descending order, values starts from null and then notice the largest number appears much later (2,946,298).

We verified the SQL generated, but it seems the sorting happens only on the front end. So, not much help with the SQL.

Anyone any idea?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2017
Added on Oct 26 2017
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
7 comments
105 views