Showing materialnumbers together with customer hierarchy in BEX analyzer

[Former Member]

Hello,

I want to show for every customer the corresponding materials sold to this customer as a hierarchy with the customer hierarchy.

The problem is now that all materialnumbers are shown under each of the nodes where they are contained. So the materialnumbers show up twice on the lower level node and higher level node. Is there the possiblility to show the material numbers only for that hierarchy node they belong to and not twice on the upper levels?

Thank you.

Regards, Lars.

[Former Member · Accepted solution]

Have you got a balanced Material Hierarchy?

ie all the lower level materials are at level 3

If so then filter the hierarchy to only the level 3 nodes (ie hard code them) - I know it's horrible but it sort of works

[Former Member · Accepted solution]

Hi Simon,

what do you mean with hardcoding?

Thanks.

Regards, Lars.

[Former Member · Accepted solution]

Restrict in the query designer against material all the level 3 nodes