cancel
Showing results for 
Search instead for 
Did you mean: 

How to create KPI's with Account and Costcenter combination.

Former Member
0 Kudos

HI ALL

Below I am illustrated my requirements to generate KPI's with combination of account and costcenter.

could be please guide me how to setup dimension formulas for following  requirements.

Challenging here is how to populate denominator with cost center Hierarchy ALL_DEPT ?

COSTCENTER / ACCOUNT Hierarchies

ACCOUNT HIERCOSTCENTER HIER
BONUSALL_DEPT
      AC1      CC1
      AC2        CC2
REV
     AC3
     AC4

Transaction Data.

AccountCostcenterTIMECATEGORYAMOUNT
AC1CC12015.01ACTUAL100
AC2CC22015.01ACTUAL200
AC3CC12015.01ACTUAL300
AC4CC22015.01ACTUAL400

KPI's list.

RESULT
KPI_1ACCOUNT.BONUS,COSTCENTER.CC1/ACCOUNT.REV.COSTCENTER.CC1100/3000.333333333
KPI_2ACCOUNT.BONUS,COSTCENTER.CC2/ACCOUNT.REV.COSTCENTER.CC2200/4000.5
KPI_3ACCOUNT.BONUS,COSTCENTER.CC1/ACCOUNT.REV.COSTCENTER.ALL_DEPT100/7000.142857143
KPI_4ACCOUNT.BONUS,COSTCENTER.CC2/ACCOUNT.REV.COSTCENTER.ALL_DEPT200/7000.285714286

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

working fine. KPI4 = ([ACCOUNT].[BONUS])/ ([ACCOUNT].[REV], [COSTCENTER].[ALL_DEPT])

former_member186338
Active Contributor
0 Kudos

No magic Absolutely standard dimension member formula.

Can be reduced to:

KPI4 = [BONUS]/([REV], [COSTCENTER].[ALL_DEPT])

[ACCOUNT]. - prefix can be removed (for account dimension only)

Vadim

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

What have you tested yourself?

Former Member
0 Kudos

Hi Vadim , I have not tested, I just mentioned expected result . I am confused how to build logic for this. thanks

former_member186338
Active Contributor
0 Kudos

You have to do at least something yourself instead of waiting for somebody with ready solution. Please read help about dimension member formulas and try to create the required: Advanced Rule Formula Examples - SAP Business Planning and Consolidation, version for SAP NetWeaver ...

Vadim

Former Member
0 Kudos

Hi Vadim , I am able to papulate formulas for below. KPI_1 ACCOUNT.BONUS,COSTCENTER.CC1/ACCOUNT.REV.COSTCENTER.CC1 100/300 0.333333333 KPI_2 ACCOUNT.BONUS,COSTCENTER.CC2/ACCOUNT.REV.COSTCENTER.CC2 I am having issue  with other two formulas ,we required COSTCENTER.ALL_DEPT. ACCOUNT. COSTCENTER/ ACCOUNT.COSTCENTER(ALL_DEPT) . how to get Account values of all_DEPT costcenters. ? thnaks