copy key figure to another changing the characteristic

[Former Member]

Hello,

I'm pretty new to macros and the problem I'm struggeling with is driving me crazy. I wanna create a macro to copy values from one KF to another and change the characteristic in the process. Someone told me that it might not even possible but maybe someone around here knows better.

KF = Key Figure
CH = Characteristic
VAL = Value

The scenario:
+======+======+=============+====
| KF   | CH   | 2012 (e.g.) | ...
+======+======+=============+====
| KF 1 | CH 1 | VAL         | ...
+      +------+-------------+----
|      | CH 2 | 0           | ...
+===========================+====
| KF 2 | CH 1 | 0           | ...
+      +------+-------------+----
|      | CH 2 | 0           | ...
+================================

After running the macro it should be:
+======+======+=============+====
| KF   | CH   | 2012 (e.g.) | ...
+======+======+=============+====
| KF 1 | CH 1 | VAL         | ...
+      +------+-------------+----
|      | CH 2 | 0           | ...
+===========================+====
| KF 2 | CH 1 | 0           | ...
+      +------+-------------+----
|      | CH 2 | VAL         | ...
+================================

To make this happen I think I need to use the agg_level() funktion to make sure that the drilldown is right but I don't know how to switch the object from one characteristic to another or how to put it all together.

Thanks, in advance.

Ben

[Former Member]

Hi Ben

Assuming I understood your requirement correctly, I have following comments:

A CVC is a comobination set with values for different characteristics . These values may not be nulll .

For each CVC we have values for different KFs,

Now you effectively want to make another CVC from existing CVC.

Creattion of another CVC from existing one may not be possible from a macro in a planning book. For each new CVC, a new time series need to be created and there are seperate programs for doing these.

Realignment may be one option.

Copying of KF may be posisble for one existing CVC to another existing CVC.

For your requirement, I think, first step will be to back up data in an infocube, carry out realignment followed by copying KF by another transaction.

Regards

Datta

[Former Member]

Ben,

You want to copy data from CVC 1 KF 1 to KF 2 CVC 2. This cannot be accomplished by a macro.

The option in front of you is to make use of the COPY functionality under realignment. I guess you should introduce another KF in the system. You can then do the following:

1). Write a macro to copy CVC1 KF1 to CVC1 KF3

2). Use either realignment or a program to copy CVC1 KF3 to CVC2 KF3

3).Write a macro to copy CVC2 KF3 to CVC2 KF2

End result is CVC1 KF1 is copied to CVC2 KF2.

Hope this helps.

Abhi

[Former Member]

Hello,

Thank you guys for helping. I was afraid you would say it was not possible. I'll evaluate your suggestions and post how I finally proceeded.

Ben