0

# Copy KF values with condition from one KF to another

Apr 16 at 08:12 AM

73

Hi Experts,

I have following situation where KF1 have values across Time horizon and KF2 have values only till 1st five years.

Requirement is to copy values of KF1 to KF2 for the years greater than 5, till end of Horizon and result shall be as below.

I have written following formulas for KF2 to achieve this, but result is not populated at all.

KF2@Request = Sum(KF2@WKPRODLOC))

KF2@YEARLOC = IF( (( "PERIODID1" - "\$\$PERIODID1CU\$\$" ) > 5) AND (( "PERIODID1" - "\$\$PERIODID1TO\$\$" ) <= 0 ), "KF1@YEARLOC" , 0)

Can you suggest what I am missing.

Thanks

Vilas Mhaisgawali

picture-1.jpg (42.2 kB)
picture-2.jpg (44.9 kB)

Rohit Ranjan
Apr 16 at 01:08 PM
0

Hi Vilas,

Without operator you could try below option-

1) Define a calculation of KF1 at WKPRODLOC using internal Join

KF1@WKPRODLOC = KF1@YEARLOC ---------> Input any Key figure at WKPRODLOC along with KF1

This makes KF1 available at WKPRODLOC

2) Use the above value to calculate KF2

KF2@WKPRODLOC = IF("PERIODID1" - "\$\$PERIODID1CU\$\$" > 5, KF1@WKPRODLOC, KF2WKPRODLOC)

3) Define request level calculation of KF2 as AVG since year value of KF1 is copied across all week in KF2 from 1st step

KF2@REQUEST = AVG(KF2@WKPRODLOC)

Thanks,

Rohit

Share
Ivan Andreis
Apr 16 at 11:31 PM
0

Hi Vilas,

If that's the case, please either close one of the threads, and we would suggest also to follow up on the original thread on this kind of cases.

Thanks for understanding;

Ivan

Show 1 Share

Hi Ivan,

Although earlier thread was copying KF values, requirement was completely different hence created a new thread. I will close the earlier thread.

Thanks

Vilas

Rohit Ranjan
Apr 16 at 09:33 AM
0

Hello Vilas,

You can use dis aggregation operator to copy value in target key figure since it is stored-

SOURCEKF = KF1

TARGETKF = KF2

ATTRIBUTE1 = LOCID

PERIODID = PERIODID1

PERIOD_OFFSET = Number of periods from where you want to copy.

Check more details in below help link-

DISSAG Operator

Thanks,

Rohit

Show 1 Share

Hi Rohit,

I prefer not to use the operator at this moment. Operator could be an option when this is non achievable via KF formula.

Thanks

Vilas