Calculated Key Figure for ISMNW

[Former Member]

Hi Guys,

I have a requirement where I have to calculate the Keyfiure into a new keyfigure from the given fields.

having filed in cube : Work ,  start date, end date and finsh date.

New CKF = sum of work where  finish date is less then or equal to Start date.

Please help how I can achieve in Bex Query.

[KodandaPani_KV]

Hi Saini,

Your problem was resoled please let me know.

Thanks,

Phani.

[KodandaPani_KV]

Hi Saini,

having filed in cube : Work ,  start date, end date and finsh date.

your cube level have Work , it is key or char?

you can't perform the calculation on char level (start date, end date and finsh date), you must convert char to KF.

it is possible to using replacement path.

please find the below document

Convert a Characteristic into a Key Figure (BEx)

Thanks,

Phani.

[Former Member]

Hi Pani,

Work is a KF . Can you please let me the logic to calculate the New KF after converting Date into KF.

[KodandaPani_KV]

Hi saini

New CKF = sum of work where  finish date is less then or equal to Start date.

After converting char to KF then apply the your formula using Boolean function at Designer level.

Thanks,

Phani.