The customer hierarchy of our client is modelised in SAP CRM as follow :
I create an infoset in SAP CRM (via SQ02) with tables :
In the Segment Builder, I make a filter on Hierarchy Node ID.
For example, I make filter on the Hierarchy Node ID of the Customer 1, as result, I get Customer 1.1 and Customer 1.2
But I want that, when I enter the Hierarchy Node ID of Customer 1, I get all customer uner him : Customer 1.1, Customer 1.1.1, Customer 1.2, Customer 1.2.1 and Customer 1.2.2 (all the levels under Customer 1).
Should I modify my infoset ? If yes what changes could I make ? Else, should I use a BW query that gives all customers linked to Customer 1 ?
Thank you in advance for your help.