How to hide the first 1 levels of Hierarchey in bex

[Former Member]

hi All,

how to hide the first Root levels of Hierarchey in bex as I marked in screen Shoot.

Thanks,

Mohan

[umashankar_poojar]

Hi Mohan,

              Why don't you change the model of your hierarchy attribute? Let's the Main attribute have another attribute(say C1), this C1 will be the attribute of your Main Attribute and maintain this C1 as to have hierarchy from 2nd Level. In your query restrict this C1 attribute and create a Hierarchy variable to select.

Hope this idea helps you!

Thanks,

Umashankar

[r_pamer]

Hi!

Selecting the nodes below the root level should work.

If it has to happen dynamically, try a customer exit variable that selects the nodes from the hierarchy table.

Best regards,

Reinhard

[Former Member]

hi Pamer,

Where I have to select the below the root level option.

rgds,

Rama Mohan

[r_pamer]

Hi!

I was refering to a filter or variable selection of the levels that are below the root level (= Territory CMD), not an option to be selected.

Best regards,

Reinhard