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

Kiran_

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)

AL.

Hello,

You can only Copy data from 1 member to another.

You would have to hardcode it.

Best Regards,

Pete N

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!