Hierarchy Last Parent value

45 Views

Hi Experrts

Im using Webi 4.1, with BICS connection.

I have an BW Hierarchy like 4 nodes, and i want to display the value in the base value and last parent only.

for example

CURRENT SCENARIO:

Product (IO) Value

ProductGroupA (TEXT node) 22

-ProductSubgroup1 (TEXT node) 15

--ProductArea1(TEXT Node) 15

---Product1 (value) infoobject 5

---Product2 (value) infobject 10

-ProductSubgroup2 (TEXT node) 7

--ProductArea1(TEXT Node) 7

---Product3 (value) 3

---Product4(value) 4

What I want to see in my report in WebI is (we can use also conditiional format if necessary) is:

ProductGroupA (TEXT node) (turn to blank)

-ProductSubgroup1 (TEXT node) (turn to blank)

--ProductArea1(TEXT Node) 15

---Product1 (value) infoobject 5

---Product2 (value) infobject 10

-ProductSubgroup2 (TEXT node) (turn to blank)

--ProductArea1(TEXT Node) 7

---Product3 (value) 3

---Product4(value) 4

How can I achieve this? there is a function isLeaf.. but it is only return me the base node.

Thanks.

Regards,