Skip to Content
Author's profile photo SESHA PS

Bex Query Output in Custom Order (Key figures Immediate to Char)

This Document will be helpful in Scenarios where :

  1. Need to Maintain Specified Order (Business Needs) in output of Bex query like displaying key figure value ‘s immediate to Char’s .

          EX :

      s1.PNG

      In General we can’t get this order in Bex query Designer (Higher versions 7.0 /7.1/7.3) .

      This is Possible only in Bex query Designer 3.x  version using Table  Display .

   2.  Need to Maintain Display attributes in Specified Order (Business Needs) .

           EX :

s2.PNG

Here Created by & Created on both  are display attributes of Material & City is display attribute of Plant.

In General we will get display attribute immediate to relevant CHAR like above we can’t change this order.

But using Table  Display (3.x) we can Change this Order like below :

s3.PNG

  Five Simple Steps for achieving this :

1.  Drag & Drop Relevant Char’s (Display Attributes) & Kfg’s   In Rows & Columns   like below :

S4.PNG

  2 . Select Table  Display icon like below  :

  s5.PNG

3. After Selecting Involved  characteristics & key figures will be displayed under columns like Below :s6.PNG

4 . Now  Based On Business Needs Change the order ( Drag & Drop ) like Below :

  s7.PNG

    Observe Here I changed order of Key figures & Display Attributes.

5. Bex  Query Output :

      s9.PNG

  

From Output , we can Observe Display attributes Created on , Location Order   & Key figures order are changed .

Note  : This Table  Display concept is available only  in 3.x Version , Not available in Higher versions (7.0/7.1/7.3).

We can use same 3.x  query  in 7.0/7.1 higher version’s after migration it will work same as 3.x ,If we have huge number of Info objects (Char’s & Kfg’s)  Preferred is Create Workbook using 3.x query in 7.0, Some times Query will create Problem’s in higher versions.

Regards,
Seshu.P

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo seshu P
      seshu P
      Blog Post Author

      Any Suggestions/Comments welcome . If any one knows how to do in Higher versions (7.0/7.1/7.3) can share.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi Seshu,

      I saw your original post on this requirement. Thanks for reminding Table Display feature in 3.X 🙂 .

      Regards,

      Suman

      Author's profile photo seshu P
      seshu P
      Blog Post Author

      Yes Suman . For my requirement i used table display  Is it Possible to change Bex query display attribute & Key figure order .

      Is it possible in Higher versions by using any alternative methods ?  Suman

      Other wise we can Request the same in Idea Place

      I think this feature will be helpful in Most of the Requirements.

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi P Seshu ,

      Have you tried to covert them as Nav Attrs and place in your required order in Query designer?

      Regards,

      Suman

      Author's profile photo seshu P
      seshu P
      Blog Post Author

      Hi Suman,

      For Display  Attributes solution is Fine , what about Key figures ?  :

      Regards,
      Seshu.P

      Author's profile photo seshu P
      seshu P
      Blog Post Author

      I think Using  one more structures /cells  also not possible  , Might be possible if we  convert char into kfg using formula variable but this is not possible for All Scenario's.