How to create Bex query structure elements dynamically?

[sankarganesh_thirumalaisa]

Hi Experts,

I have a Bex query which is having a structure with 800 elements based on entities and if there is a new entity then the structure needs to be manually changed in query and the new entity added.

To avoid this manual activity we are trying to build a dynamic structure elements based on the back end table entries. Is it possible to do this? also is it possible to change property of element like display or hide the element?

Instead of structure we can go with Hierarchy but in hierarchy we cant add a selections to the particular node.and we cant change change the display property of a node.

Could you please check and suggest your inputs.

Many thanks in advance!

[kohesco]

Hi,

you can add a new z* infoobject to your dataflow. Applying the same logic as in your structure (the filtering/selections), please try to group your infoobjects values and use those groups into your new z*infoobject. When you have structured the data correctly, new entries should be loaded into the correct groups and no manually work should be needed. You can set the rows to display as hierarchy in the query designer, so maybe you do not need to have a hierarchy. To dynamically show/hide, zou can use filters/prompts/variables and when they are complex you can save them as variants so you can easily and swiftly reuse them.

Grtz

Koen