on 11-24-2012 9:26 AM
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!!!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.