Skip to Content
0

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

Oct 21, 2016 at 08:00 PM

53

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Juan Carlos Crespo Rojas Nov 04, 2016 at 03:45 PM
0

Hi Vadim

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

Regards,

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Can you show screenshot of account hierarchy?

0