Copy totals from KF 1 to detail level 1 of KF2 using Macro.

[Former Member]

Hi ,

Scenario:

Location : L100, L200

SKU: P1

KF1 Total 1000

       L100,P1-500

       L200, P1-500

Now I want to copy 1000 Total of KF1 to L100,P1 of KF2

KF2 Total-1000

        L100,P1- 1000

        L200,P1-0

I am trying to use DRILL UP /AGG_LEVEL function, but would be great if someone can help me.

Thanks,

Sai

[rajkj]

Hi Sai,

You can use TS_SET and TS_GET macro functions to copy data selectively. Pl refer 9AEXAMPLES for help on these macro implementations.

Thanks,

Rajesh

[Former Member]

Thank you for reply. But I actually used dis aggregation to achieve this. I used a 3rd KF and set 100% in L100 P1 and changed KF settings of KF2 (P based on KF3). Then created a AGG level copy macro. It did the job.

Closing...

Thanks,

Sai