cancel
Showing results for 
Search instead for 
Did you mean: 

Webi bex hierarchy get leaf node

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Sorry, didn't realize that I sent out link with Port number.

There are multiple member set functions available within WebI that allows to define hierarchy nodes. (Descendants, children, Isleaf, depth Etc.,). you can find these under "Set" within a variable.

Below link will give you more insights:

https://answers.sap.com/questions/10718327/how-to-use-the-set-functions-effectively-in-webi-p.html

Can you try:

={BExhiername].Children member set to get children of the parent hierarchy.

Thanks,

Jothi

0 Kudos

Hye.

I have tried [hierarchy bex name].chlidren

It sends me error message « error in expression ».

I tried the function ascendant descendant children, i always have error message with bex hierarchy.

I think it is not possible or i do not process in good way. Can you give me an exemple with bex hierarchy please ? I really do not understand.

Thank you.

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Try using .Isleaf/.Children member functions within WebI.

http://10.10.118.61:8080/BOE/portal/1608070656/AnalyticalReporting/help/en/frameset.htm?471909686e04...

Thanks,

Jothi

0 Kudos

Jothi,

Thank you for your answer.

I do not know how i can achieve What i want. I do not manage to access your link. Can you explain your idea please ?

Thank you.

Best regards.