on 01-04-2016 1:12 PM
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 HIER | COSTCENTER HIER |
BONUS | ALL_DEPT |
AC1 | CC1 |
AC2 | CC2 |
REV | |
AC3 | |
AC4 |
Transaction Data.
Account | Costcenter | TIME | CATEGORY | AMOUNT |
AC1 | CC1 | 2015.01 | ACTUAL | 100 |
AC2 | CC2 | 2015.01 | ACTUAL | 200 |
AC3 | CC1 | 2015.01 | ACTUAL | 300 |
AC4 | CC2 | 2015.01 | ACTUAL | 400 |
KPI's list.
RESULT | |||
KPI_1 | ACCOUNT.BONUS,COSTCENTER.CC1/ACCOUNT.REV.COSTCENTER.CC1 | 100/300 | 0.333333333 |
KPI_2 | ACCOUNT.BONUS,COSTCENTER.CC2/ACCOUNT.REV.COSTCENTER.CC2 | 200/400 | 0.5 |
KPI_3 | ACCOUNT.BONUS,COSTCENTER.CC1/ACCOUNT.REV.COSTCENTER.ALL_DEPT | 100/700 | 0.142857143 |
KPI_4 | ACCOUNT.BONUS,COSTCENTER.CC2/ACCOUNT.REV.COSTCENTER.ALL_DEPT | 200/700 | 0.285714286 |
working fine. KPI4 = ([ACCOUNT].[BONUS])/ ([ACCOUNT].[REV], [COSTCENTER].[ALL_DEPT])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What have you tested yourself?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.