2 Replies Latest reply on Dec 18, 2015 3:01 PM by cesar.advincula.o

    sorting order is missing for a column in pivot table view.

    3027402

      Hi

       

      I have an Issue that is sorting order is missing for a column in pivot table view. In table view its working fine but the I want it group wise.

      Can anybody please help to resolve this issue

       

      Thanks

      Navanitha

        • 1. Re: sorting order is missing for a column in pivot table view.
          Ebin

          Hi Navanitha,

           

          If possible, attach screenshot of the issue or share more details on your requirement.

           

          Thanks

          Ebin

          • 2. Re: sorting order is missing for a column in pivot table view.
            cesar.advincula.o

            Hello Navanitha,

             

            1. Try to force is USE SET ORDER BY COLUMN, in THE LOGICAL TABLE PROPORTIES of BUSINESS MODEL AND MAPPING LAYER, "CHECK IN" the repository and

               "Reload Metadata" in OBIEE Answers.

            2. Put any column with number format at same level of data that you want to source, and HIDE this column in OBIEE.

             

            If any these WORKAROUND doesn't solve the problem, please check your physical query:

             

            Please put your user and in the repository inside go to manage-> identity -> Action -> Set Online User -> Enter the user that you use to test your result in Answers.

                Open your report "Analysis", go to Administration-> Manager Session and check how the OBIEE SERVER create the QUERY.

             

            Kind Regards,