Manohar Paleti

My photo
Hyderabad, AP, India
Working as a BI Consultant, Served for various organizations as an OBIEE Developer by building the BI Solutions for Business Decision Making..

Monday, October 22, 2012

Sorting Issue - Pivot table OBIEE 11g

Hi Folks,

I'm back again after a long time with an interesting post
an often Issue after up grading from 10g to OBIEE 11g -- Pivot table in 11g is not in order like 10g.
Ex:- Customer ID,Customer Name and #Orders
if, its not in same order as like in 10g ???
No worry, work around is duplicate the measure column and place it in left side of row section and hide it .

Now, its DONE -- !!!

Note: As OBIEE 11g sorts the columns from Left to right, so keep the one which needs to be sort at left most side to get the exact sorting...!!!


Thanks,

Posted by at

6 comments:

  1. Sara Jones21November 25, 2012 at 8:57 PM

    Very helpful articles you have here. thanks and plz keep updating! OBIEE Online Training

    ReplyDelete
  2. mehak kashishSeptember 2, 2013 at 5:44 AM

    too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 11 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, obiee training in hyderebad

    ReplyDelete
  3. AnonymousMay 20, 2014 at 9:08 PM

    pivot grid data table sorting

    ReplyDelete
  4. vatsal kapadiaAugust 17, 2015 at 9:04 AM

    It's not working in my case and I have been observing that in Pivot view the sorting takes place only on the dimension columns and not on the measures whether you keep them hidden or visible. The sort order starts from left to right only on the DIMENSION columns. Please let me know if we have any other workaround for the same.

    Thanks,
    VK

    ReplyDelete
  5. UnknownSeptember 11, 2015 at 4:24 AM

    Hi, please try this.
    work around is duplicate the dim column and place it in left side of row section and hide it (make sure to apply sorting on dim col in criteria section) .
    Good luck.

    ReplyDelete
  6. M. HusainSeptember 5, 2017 at 10:08 PM

    And How do we do this in Graph?

    ReplyDelete

Subscribe to: Post Comments (Atom)