You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Copy data from one member to other members of same dimension (fastest way)

Accepted answer
112
Views
6
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!