Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Help needed with business rule data copy from level 1 to level 0 of a dimension

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)
Answers
-
Hello,
You can only Copy data from 1 member to another.
You would have to hardcode it.
Best Regards,
-
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!