Skip to Content
author's profile photo Former Member
Former Member

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

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
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2016 at 10:50 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2016 at 04:08 PM

    What have you tested yourself?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.