Forum Stats

  • 3,826,893 Users
  • 2,260,722 Discussions
  • 7,897,116 Comments

Discussions

Help needed with business rule data copy from level 1 to level 0 of a dimension

Kiran_
Kiran_ Member Posts: 81 Red Ribbon
edited Jun 4, 2019 6:32PM in Planning and Budgeting

Hello community,

I am new to EPBCS and currently implementing it. I am trying to create a rule/script (still unclear as to the difference between terminology) to copy data from level 1 members to level 0. Below is the script that I wrote which gives me a syntax error upon validation. My end objective is to multiply an Employee's FTE % (input by the user as a driver) by his average office hours (which is what I am trying to copy to a level 0 in order to be at the same level as the remainder of the budgeting process)

Please let me know if I should be providing additional information.


thanks in advance,

Kiran

FIX (/*DIM:Account*/"Courbe Heures Normales"

,/*DIM:Years*/(&OEP_CurYr)

,/*DIM:Scenario*/"OEP_Plan"

,/*DIM:Version*/"Courbes"

,/*DIM:Service Specialty*/"No Service Specialty"

,/*DIM:Client*/"No Client"

,/*DIM:Employee*/"OFS_No Employee"

,/*DIM:Plan Element*/"OFS_Direct Input"

,/*DIM:Entity*/"OEP_no entity"

,/*DIM:Period*/@IDescendants("YearTotal")

)

ENDFIX

datacopy @levmbrs("Grouping",1) to @levmbrs("Grouping",0)

Tagged:

Answers

  • AL.
    AL. Member Posts: 265 Blue Ribbon
    edited Jun 4, 2019 3:48AM

    Hello,

    You can only Copy data from 1 member to another.

    You would have to hardcode it.

    Best Regards,

  • Pete N
    Pete N Member Posts: 77 Blue Ribbon
    edited Jun 4, 2019 6:32PM

    That's true-ish. A datacopy can only work hardcoded. But you should still be able assign the values.

    FIX (/*DIM:Account*/"Courbe Heures Normales"

    ,/*DIM:Years*/(&OEP_CurYr)

    ,/*DIM:Scenario*/"OEP_Plan"

    ,/*DIM:Version*/"Courbes"

    ,/*DIM:Service Specialty*/"No Service Specialty"

    ,/*DIM:Client*/"No Client"

    ,/*DIM:Employee*/"OFS_No Employee"

    ,/*DIM:Plan Element*/"OFS_Direct Input"

    ,/*DIM:Entity*/"OEP_no entity"

    ,/*DIM:Period*/@IDescendants("YearTotal")

    ,/*Grouping*/@relative("Grouping",0)

    )

    OFS_Direct Input = @PARENTVAL("Grouping","OFS_Direct Input");

    ENDFIX

    Will iterate through the lowest level grouping members and assign the value from OFS_Direct Input That said, I don't think that is where your data actually is? you might be better off just doing the final step (Net_Office_Hours = "Employee FTE (%)" * @PARENTVAL("Group", "Office hours");  or something? No point moving the data if you don't have to. On that though - generally we store global assumptions against a Group_NA or No_Group rather than at a summary level. Less risk of it getting blown away if someone accidently aggregates the hierarchy!