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

Is it possible to perform calculation using dimension property values

Hi Guys,

I am working on Resource planning (Billable hrs). Here is my scenario

Dimensions want is used it in my calculation :

1) KPI : Billable Hours

2) Employee (Property: Price per hour)

When a manager plan the billable hours would like to see calculation of Revenue . This should be Billable hours * Price per hour

I am not able to put this statement in my Logic script. Any possibility to use dimension property value in script logic i.e., in REC statement. Can you please help me out.

Regards,

BR

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 24, 2013 at 04:42 PM

    Hi,

    I do not recommend you to use numeric values in the properties in calculations. It's possible in some cases but will require very slow FOR/NEXT loop.

    Use additional members to store the required values instead of properties. The FLD operator is still missing in BPC NW.

    B.R. Vadim

    P.S. In your case you have to add member PRICE and fill it with price per hour. If it's a permanent value you can put it on some dummy members of all other dimensions.

    Message was edited by: Vadim Kalinin P.S. Added

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vadim,

      Instead of using property value (Numeric) in calculations I did it in this way.

      Created a property called Group in the Dimension (Employee).

      Ex: A, B, C & D . This will be used in my logic script

      //Calculate the revenue from the billable hours and price per hour

      *WHEN C_EMPLOYEE.GROUP

      *IS A

      *REC(EXPRESSION = %VALUE% * 50 ,C_KPI = REV)

      *ENDWHEN

      *WHEN C_EMPLOYEE.GROUP

      *IS B

      *REC(EXPRESSION = %VALUE% * 100,C_KPI = REV)

      *ENDWHEN

      *COMMIT

      I think its easy for Admin team to maintain the master data and in the same time don't expect many changed in the price per hour (Employees)

      Do you see any other approach.

      Regards,

      BR

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2013 at 11:15 AM

    Hi,

    How do you propose to calculate in cases where the employees have the same Price per hour?

    Wouldn't it be better to have Price as a Statistical Account in your Account Dimension and then do a simple *REC statement to multiply Billable Hours with Price/Hour.

    You could have one input form for each of these input, post which the Amount is automatically generated in BPC

    Regards,

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      For this simple case (only 2 variants) it's possible to use property, but any changes will require to change script. And it will require the administration team involvement. This is not a good practice.

      The dedicated account is better.

      By the way, *COMMIT is useless in your code, at the end of WHEN/ENDWHEN loop autocommit happens.

      Vadim

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.