Hiding hierarchy level in Report (Query Designer)

[Former Member]

Hallo Experts,

I am working on a hierarchy structure. I use the activate Hierarchy Display in the Query Designer. I try to expand my query till level "2".

But I actually want only the 2 level report and the 1st level should be hidden. Can anyone guide me how this can be done.

Thanks in advance

Santosh

[Anand71]

Hello Santosh,

You can have Level 2 as an InfoObject that will be attached to 0MATERIAL as a navigational attribute. Then you can use this in your report and and create a condition on it.

Thanks.

With regards,

Anand Kumar

[former_member183777]

Not sure but,,, try excluding the higher level node and including the second level in the filter settings