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

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. seshu P Post author

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

    (0) 
          1. seshu P 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.

            (0) 

Leave a Reply