This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,524 Users
  • 2,269,776 Discussions
  • 7,916,824 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!