Webi bex hierarchy get leaf node

hello,

I need your help on webi on bex query.

I want to create a table with the hierarchy (bex) and second column all leaf node.

For exemple if i have a hierarchy :

+ Level 1

+ Level 1_2

LeafNode 1_2_1

+ Level 1_3

LeafNode 1_3_1

LeafNode 1_3_2

I want to create a table which contrains on first column the hierarchy And the second the leaf node. In m’y example, i want :

Column 1 Column2

+ Level 1 LeafNode 1_2_1

+ Level 1 LeafNode 1_3_1

+ Level 1 LeafNode 1_3_2

+ Level 1_2 LeafNode 1_2_1

LeafNode 1_2_1 LeafNode 1_2_1

+ Level 1_3 LeafNode 1_3_1

+ Level 1_3 LeafNode 1_3_2

LeafNode 1_3_1 LeafNode 1_3_1

LeafNode 1_3_2 LeafNode 1_3_2

Hope you have understand my issue.

Thank you.

Best regards.