IBP: Copy from LocalMemeber to Kf

[OliverA41]

Hello,

I have values in different LocalMemeber KF. Is it possible to copy this values in "normal" IBP KF's ?

Regards

Oliver

[peter_casper · Accepted solution]

Hi Oliver,

actually you just need to create a new key figure of type "calculated key figure" within the planning area app (planning area > key figure > new > {select calculated only}).

Afterwards it's necessary to apply the same logic via HANA coding in the calculation section. This might become a challenge or even impossible dependent on the complexity of your Excel formula.

Another option would be to use the capabilities of Excel. You could do the lookup from planning view 1 (where your local member kf gets calculated) with formula "sumifs()" using your 3 key fields mentioned above. That works pretty well. However it's necessary to keep the performance in mind.

best regards, Peter

[OliverA41 · Accepted solution]

Hello Peter,

thank you for your response.

We cannot create a kf, wich can calculate SQRT.

also the "sumifs()" is not usable. Currently I create an VBA script but the performance is not so good

Other ideas will be create.

Regards

Oliver

[peter_casper]

Hi Oliver,

it depends on your intention of how to copy. You can't copy values of a local key figure based on a predefined operator due to the fact that the local member isn't know to the backend.

However you can copy the local member KF values within the Excel frontend to an editable stored KF, either via formula, macro or simply via copy and paste.

Not quite sure if your question was about this.

Best regards, Peter

[peter_casper]

Hi Oliver,

this means the option to transform your Excecl calculation into a KF based one is not possible. If this is the case then the only option will be to make use of Excel capabilities. Now it's hard to judge why the sumifs() function does not work w/o knowing the concrete setup and the keys of your 2 planning views. Also the performance of the VBA strongly depends on the coding. It usually goes down dramatically if one makes use of nested loops (similar to any other programming language). There might be the possibility to combine your VBA with some precalculated Excel formulas in order to avoid building up internal comparison keys for the lookpup in VBA. But as said, hard to judge on pure theoretical basis.

Best regards, Peter

[OliverA41]

Hi Ivan,

that is an interesting way. It's new, that I can do this. How can I replace an Local Memeber through an KF ?

Regards

Oliver

[former_member194529]

Hi Oliver,

It won't be possible to use an IBP copy operator for this process since Local Member values are not stored on the back-end. Have you considered an alternative modelling approach where the local member itself could be replaced by a new Key Figure calculated in HANA instead?

Best,

Ivan

[OliverA41]

sounds intresting, can you give me more details how I can do this ?

Thanks in advance

[OliverA41]

Hello Anna, hello Peter,

thanks for the repsonse.

You are right, if the kf editable than I can copy and paste values.

But my task is follow

I have in one planning view a calculation of a local member of an determine produkt-customer-location.

In an other planning view, I have a kf which should be save the result the calculation which is in the local memeber. Now I have , to find in the second Planning View the correct product.-customer- location combination.

Currently I have create an VBA script which do this, but the performance is not really good. For that reason, my idea was, that I can you the copy operator to copy the values.

Regards

Oliver

[anna_linden]

Hi,

if the other IBP key figure is editable, yes.

VG Anna