Hi all,
I would like to use a cell value as a member name in a business rule. I am doing a POC for mass transfer of employees in Workforce, basically users would need something on the data form to do a one time mass update to move lets say 100 employees between Cost centers. They dislike doing the transfer one employee at a time. So here is what I am thinking, create a form with all the employees and their existing cost center and entities and create two stat members in account dimension 'SourceCC' and TargetCC' and use these members to hold the old and new costcenters as a cell value. And in the business rule I will use these cell values as member names to do a datacopy, but no matter how I try its not working out. Is there a function that can be used to achieve this, I tried @member, @name, @hspnumtostring but its not working out.
Form
---------
SourceCC TargetCC
EMP1 CC4410 CC5100
EMP2 CC5100 CC5500
EMP3 CC7100 CC2100
Business rule would be something like this
DATACOPY "EMP1"->"SourceCC" to EMP1->"TargetCC";
I would appreciate if youcould help me solve this, I am open to other ideas if anyone tried earlier to achieve the mass transfer.
Thanks
MJ