SAP HANA PARENT-CHILD HIERARCHY AND AGGREGATION

[former_member367466]

Good Evening,

Could you please provide tips on how to accomplish the following requirement?

Our client wants to see the count at each node for reporting depts. Only. If the node has dependent hierarchy the counts not added to previous node as described below.

Hierarchy looks as under:

TREE NODE LEVEL PARENT NODE PARENT LEVEL

0000000025 1

0000000026 2 0000000025 1

0000000029 2 0000000025 1

0000001123 2 0000000025 1

0000001122 2 0000000025 1

0000020001 3 0000000026 1

000030001 3 0000000029 1

Hierarchy looks as under

Hierarchy count

0000000025 6

00000000026 1

00000200001 1

00000000029 1

00000300001 1

00000001123 1

00000001122 1

In the above scenario, only the last 2 dept reporting to 25. So the client would like to see the count as 2 only

In parent child relationship, regardless it adds to the count. at each node level. I'm using webi to display the results.

Can you please provide some tips?

Thank you,

William