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

  • 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

    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

    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

    • Hello Anand,

      Unit is coming but it is showing above the column.

      I need to show that unit with every value of the field.

      Please check my screenshot attached there

      Thanks,

      Ipsita

  • Feb 21, 2017 at 07:58 AM

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

    Add comment
    10|10000 characters needed characters exceeded