IBP - Copy Key Figure Value of the current month to future Periods of the same Key Figure

[former_member666725]

Hi IBP Experts,

I have a requirement "Copy Key Figure Value of the current month to future Periods of the same Key Figure".

Eg: If I have a value in April-2021 month as 1000 then the same 1000 should be copied across to future periods/months either via a copy operator (profile) or any other simple functionality in IBP.

The value in the current month has to be copied into the future periods of the same Key figure.

Appreciate your help.

Thanks in Advance.

Parthi

[AyanBishnu · Accepted solution]

Hello Parthi

My solution will be a bit out of the box approach, but i think that this is the easiest way to acheive the requirement you have.

Take 2 KFs ( e.g KF1 and KF2) and both the KFs should be sharing the same base PL.

Make KF1 as stored KF,where you will put the value as 1000 in the first bucket only. Rest all buckets should be NULL or zero.

KF2 will be a calculated KF where you can use the CAGGR funtion in the expression to acheive the solution. Below is the expression for your reference.

KF2@BASEPL=IBP_CAGGR("KF1@BASEPL" , ''SUM'' , ''FORWARD'' , ''CURRENTFUTURE'')

so you input the value 1000 in the curret bucket of KF1 and the same value appears at all the buckets in KF2.

Let me know if that works

[anamika_mudgal · Accepted solution]

Hi Ayan ,

I have also some Req .I am trying to understand your explanation here , how cumulative aggression help to copy exact same number ? It will not copy the bucket cumulative.Eg. W1 will copy to W2 then W3 and so on . Also in the expression , we don’t need to mention any time level in last , that is after Current Future ?

[victorhugo_leao]

Hi Parthi,

I have the same requirement.

Did you find the solution?

Best regards,

Victor

[nazarali1308_37]

I too have the same requirement, any possible solutions?

Regards,

Nazar Ali

[girish_nitie34]

In any solution, you will need another KF2 to calculate this and at the end you need to copy KF2 into KF1 by using copy operator.

[former_member666725]

Hi Ayan Bishnu,

Thanks for your solution.

1 ) This works for another Key Figure but not for the same Key Figure.

2 ) The requirement is "Copy Key Figure Value of the current month to future Periods of the same Key Figure".

Please let me know if you have some other solutions.

Thanks in advance.

Appreciate your help.

[reddyatoz]

Hi Parthi,

I have the same requirement.

Did you find the solution?

Br

Kumar

[girish_nitie34]

In any solution, you will need another KF2 to calculate this and at the end you need to copy KF2 into KF1 by using copy operator.