Skip to Content

BEX Query issue

Hello Experts,

How can I show my all characteristics in a hierarchical manner in bex query output.

Please check the screenshot.Those 4 characteristics are added in ROW section of a query .How can I show those characteristics in the hierarchical manner showed in the screenshot.

capture.png

Thanks,

Ipsita

capture.png (15.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Feb 20, 2017 at 01:40 PM

    Hi Ipsita,

    Either you create your own hierarchy or you display your characteristics as a hierarchy:

    Regards,

    Frederic


    capture.png (39.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 07:17 AM

    how about creating a hierarchy on that characteristic?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2017 at 06:32 AM

    Hello Frederic,

    Thank you for your help.I have used your technique and the result is coming as desired .

    I need one more help .The unit is not coming with the value of some fields.

    Do you have any idea for which setting it is not coming?

    The unit is showing above the column.

    Please find the screenshot .

    capture.png.

    Thanks,

    Ipsita


    capture.png (21.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2017 at 06:57 AM

    Hi,

    Put Unit info object in columns below key figuers.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2017 at 07:58 AM

    Check the behavior of your query when changing the parameter "Display scaling factor".


    capture.png (10.1 kB)
    Add comment
    10|10000 characters needed characters exceeded