SAP BPC 10 NW - Member formula - Is there a way to get the current member hierarchy name?

[former_member273453]

Dimension type: Category

# Hierarchies: 2 - PARENTH1 & PARENTH4

Is there a way to dynamically get the hierarchy name of the current member, in order to calculate some KPI where dimension has 2 hierarchies.

I've tried the following function unsuccessfully:

Goal: Percentage of revenue based on current member hierarchy

*function PctRev(%VERSION%) IIF([ER_ACCOUNT].CURRENTMEMBER.HIERARCHY.NAME="PARENTH1",(([ER_ACCOUNT].CURRENTMEMBER,%VERSION%)/([ER_ACCOUNT].[PARENTH1].[PL_INC],%VERSION%)),(([ER_ACCOUNT].CURRENTMEMBER,%VERSION%)/([ER_ACCOUNT].[PARENTH4].[REV],%VERSION%)))

*endfunction

Thanks in advance

[former_member186338]

Sorry, but what do you mean by %version%?

[former_member273453]

Hi Vadim

Thanks for your responde, Version variable sets the Category dimension element, for example Actual

Regards,

[former_member186338]

Can you show screenshot of account hierarchy?