Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 04, 2016 at 03:45 PM

    Hi Vadim

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

    Regards,

    Add comment
    10|10000 characters needed characters exceeded