Advice on smart use of DATACOPY

@MATCH(SparseDim

Hi all,

I'm looking for advice on how to improve my code regarding the use of DATACOPY.

I have a sparse dimension that looks similar to this:

RootMbr

     Parent_1

          Legacy_1

          Child_1_1

          Child_1_2

          Child_1_3

     Parent_2

          Legacy_2

          Child_2_1

          Child_2_2

          Child_2_3

     Parent_3

          Legacy_3

          Child_3_1

          Child_3_2

          Child_3_3

     Parent_...

I'm not getting into details, but at some point I need the parent value of Parent_X to be copied to Legacy_X

I first solved this using the following:

FIX(@MATCH(SparseDim,"Legacy*")

@PARENTVAL(SparseDim,@CURRMBR(SparseDim));

ENDFIX

Now I've realized blocks are not being created for Legacy* members, and using block member calculations like cannot be done this time (for reasons I'm not detailing this time).