How to use Alert Key Figure value filter in copy operator?

[priyankachauhan1409]

Hi All,

We have requirement to create copy operators for updating values of new combination of cost key figures at Tech Week as follows:

First Copy operator: This will aggregate values(copy) of cost key figure from Tech Week to Month at Cust Region and Sub Product line

Second Copy operator: This will disaggregate values (copy) of Key figure from Month to Tech Week level. (The result will be cost values will be copied for the new combination also)

Third Copy Operator: This is where we are stuck! This copy operator should clear out values from only time buckets of cost key figures where consensus demand is not present in the same time bucket. How can we achieve that if in case we want to run operator only for the above delta combinations and not entire Customer Region and Sub-Product Line combination? We thought of using Alerts Key Figure which will let us know if in case consensus demand is present, but cost is Null. However, how to use an Alert Kefigure in running a copy operator?

Any other approach to achieve the above desired results in 3 copy operator are also welcome.

Thanks & Regards,

Priyanka Chauhan

[avijit]

Dear,

A Copy Operator (at Step 3) doesn't fit the requirement. Clear Values parameter in the Copy Operator, when set to Yes, will set the Target Key Figure value to NULL for all the Time Periods that falls within the Start & End Period.

Best regards,
Avijit