Skip to Content
0
Former Member
Nov 24, 2012 at 09:26 AM

Need some examples on Member, Self After, Self Before funcitons used with Hierarchy object in Webi 4.0.

1054 Views

Hi All 😊

I'm using BICS connection for webi in BO 4.0 SP04 Patch 6.

I know the usage of function isLeaf() which is useful with Hierarchical objects to check whether it is Child Node or Parent Node. But i'm confused with Self After, Self Before, etc functions useful with Hierarchical Objects. Please help me by explaining with Examples.

Is it possible to perform If conditions to check any of the child's Revenue is zero and if so, return 0 or divide by Total Revenue. And i want to Sum the Result returned by above if condition.

For Example, If 'Revenue of Child1' is not 0 then (Child1's Revenue/Total Revenue) + if 'Revenue of Child2' is 0 then 0 + If 'Revenue of Child3' is not 0 then (Child3's Revenue/Total Revenue).

Note: i want to calcuate only for particular parent node in the list.

Thanks in Advance!!! 😀