Copy data from one member to other members of same dimension (fastest way)
Hello experts,
I have to copy data from one member to anothers of same dimension and I ask you which is the best and fast way to do it.
My requeriment is copy data from Entity_NA to all of other entities (Entity is Sparse dimension)
Actually I have this code:
FIX("FY29","Actual","Local","NF","BegBalance","Acc_01",@RELATIVE("Customers",0 ),@RELATIVE("Employees",0 ),@RELATIVE("Dpto",0 ))
DATACOPY "Entity_NA" to "Entity1";
DATACOPY "Entity_NA" to "Entity2";
DATACOPY "Entity_NA" to "Entity3";
DATACOPY "Entity_NA" to "Entity4";
DATACOPY "Entity_NA" to "Entity5";
ENDFIX
This code is very fast (about 1 min of execution and I have blocks for each entity). This code works but the problem is hardcoded, If I have new entities I have to open rule and add it.