Key figure copy from one location to another in same PA

[former_member598176]

Hi,

We have a requirement to copy values of a particular keyfigure for Location 1 into values of same key figure for Location 2 in the same planning area/book - and both are time series KFs.

Is it possible to do it with macros? Can anyone please share a sample macro or guide how to go about it?

Note: I have gone through old scn discussions but did not find useful specific help.

[tabraiz_khan]

You have two options:

1) Copy from the backup cube using RTSCUBE report if data exists in the level you expect

2) Macro: Run this at the required level. You will get the desired data copied.

Level 1: Select Range

  Level 2: Select Step

    Level 3: Row <Target KeyFigure> =

      Level 4: Row <Source Key Figure>

Thanks,

Tabraiz