Greetings Planning Experts,
In Hyperion Planning On Prem version 11.1.2.4.0.79, we have a workforce application in which we have to update the Pay Grade of multiple employees at one time in a form. When the Pay Grade is updated, the Business rule should calculate the Salary Rate which corresponds to the Pay Grade in another look up table.
The problem is there are thousands of Employees and there are other custom dimensions such as Location, Company Code, Job ID, Cost Center, Department Code and Employee Job ID Code (this is a separate dimension from Job Code).
Without fixing on a single employee if i run the rule for multiple employees using the following rule, it takes forever ....since there are 3000 employees, there are more than 300 Cost Centers, 100 job ID titles, 1800 Employee Job Code IDs and so on
FIX ({Scenario}, {Version}, &BudgetYear, BegBalance, @RELATIVE (Location, 0), @RELATIVE (Company, 0), @RELATIVE (Employees, 0), @RELATIVE (Department Code, 0)
.................Get the Salary Rate on basis of Pay Grade.....................
.............................
............................
ENDFIX
Is there a way to identify in the form and Business Rule, which were the Employees whose Pay Grade was updated and then run the Business rule for only those employees.
Any ideas would be extremely helpful!
Thanks,
Pete`