Skip to Content

SAP PCM 10. Resource driver calculation.

When creating rule to Resource Driver to calculate RD using REASSACTMENTLINEITEMVALUE table (grid). We tried to use POSTREASSIGNLINEITEMVALUE, REASSIGNACTIVITYLINEITEMVALUE function’s in "Detailed Resource Driver Split Rule". When we running this function’s our system begin work very slowly.

We tried to use RESTRICTDIMENSION, RESTRICTDIMENSIONPARENT function’s to limit scope. When we using it, calculation result is null.

Rule code:

Function CellValueRestrictDimensionParent("LINE ITEM","GR106")    CellValue = ReassignActivityLineItemValue(,,"CO7200")End Function

Table REASSACTMENTLINEITEMVALUE content:

Periods

Responsobility Center

Line Item

Target Responsobility Center

Target Activity

ReassignActivity

LineItemValue

201201

CO7200

4301_98_0000

CO7200

UX13

-56545018

201201

CO7200

7101_98_0000

CO7200

UX13

-83379000

201201

CO7200

7102_98_0000

CO7200

UX13

-133716000

201201

CO7200

4301_98_0000

CO7201

UI01

514902,79

201201

CO7200

7101_98_0000

CO7201

UI01

759254,87

201201

CO7200

7102_98_0000

CO7201

UI01

1217627

201201

CO7200

4301_98_0000

CO7205

UI01

14980562

201201

CO7200

7101_98_0000

CO7205

UI01

22089732

201201

CO7200

7102_98_0000

CO7205

UI01

35425594

201201

CO7200

4301_98_0000

CO7207

UI01

10556919

201201

CO7200

7101_98_0000

CO7207

UI01

15566806

201201

CO7200

7102_98_0000

CO7207

UI01

24964693

201201

CO7200

4301_98_0000

CO7211

UI01

2579500,8

201201

CO7200

7101_98_0000

CO7211

UI01

3803627,7

201201

CO7200

7102_98_0000

CO7211

UI01

6099927,9

201201

CO7200

4301_98_0000

CO7212

UI01

264085,05

201201

CO7200

7101_98_0000

CO7212

UI01

389409,15

201201

CO7200

7102_98_0000

CO7212

UI01

624500,58

201201

CO7200

4301_98_0000

CO7214

UI01

5616786,1

201201

CO7200

7101_98_0000

CO7214

UI01

8282285,9

201201

CO7200

7102_98_0000

CO7214

UI01

13282411

201201

CO7200

4301_98_0000

CO7215

UI01

169344,79

201201

CO7200

7101_98_0000

CO7215

UI01

249708,99

201201

CO7200

7102_98_0000

CO7215

UI01

400461,59

201201

CO7200

4301_98_0000

CO7217

UI01

3472550,7

...

Maybe we using wrong function’s, or wrong using this function’s? Help please.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 22, 2012 at 10:25 AM

    Hi Ivan,

    The only way to calculate Resource Drivers Splits to be equal to a post-reassignment activity value in PCM, is to use several versions or to use an export-import console script. You might also need 1 driver for each lineitem depending on what you are trying to achieve.

    If you go for the versions, the first version will calculate the reassigned values. The rule restricted on the second version will then be able to 'read' these values from the first version, populate the ressourcedriversplits and perform the full calculation.

    Another issue with the rule that you are trying to setup is that the restriction is on the line item dimension, which is not part of the grid value you are calculating (resourcedriversplits are by version, period, RC and activity).

    Allocating costs to the prorata of already allocated costs means that the business rule is not mature enough and you migth want to find a better suited driver. But this is another debate.

    Hope this helps

    Best regards

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2013 at 12:54 PM

    Sweta

    Please do not forget that populating resource driver values or splits (or activity driver values) instead of using vbscript rules is much faster when it is time to calculate the model.

    The key words supported by VBScript are supported by PCM as it is using by default the windows library. You can use variables and a select...case statement. The rule would then look like this:

    Function cellvalue()

    RestrictDimension("Activities","Act1")

    RestrictDimension("Activities","Act2")

    RestrictDimension("Activities","Act3")

    Dim RDS

    select case itemname(currentactivity) 'I am guessing that "Actn" is the default alias

    case "Act1"

    RDS=10000

    case "Act2"

    RDS=20000

    case "Act3"

    RDS=70000

    end select

    CellValue=RDS

    End function

    regards,

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

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.