cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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!!!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can for example check if the sum of descendants to a member are zero comparing to a formula similar to this one:

=Sum( [KPI1] ; Descendants([Hierarchy];1;Self_After))

Check following blog to see hierarchy formulas in action:

http://www.trustedbi.com/2012/05/29/secret-formula/

Best regards,

Victor

Answers (0)