cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Operator - How to create value 0 or NULL in target if value of source is NULL?

vincentverheyen
Active Participant
0 Kudos
626

Dear experts,

Let's assume we have a Copy Operator with a Source Key Figure that has value NULL (that is: no value) in a certain Period. How can we make sure that, for any such Period, the Target Key Figure yields a value of 0, instead of having no change in the target's original value, for that Period. That is: how can we erase the value in the target's Key Figure or replace it by 0, for such periods.

Is this possible using some setting in a Copy Operator, or a variety of Copy Operators sequentially? Or is the only possibility to use a Calculated Key Figure (for example change the calculation in the source Key Figure, to replace NULL with 0), instead or in combination with a Copy Operator?

Accepted Solutions (0)

Answers (1)

Answers (1)

vincentverheyen
Active Participant
0 Kudos

In general, there is no need to introduce a second step in the Key Figure Selections, or alternatively change the Calculation of the Source Key Figure, as it is the default behaviour (to have an empty in target Key Figure when source Key Figure is NULL) when using a Copy Operator, so no adjustments are required.

However, in some cases there might not be a Planning Object yet in the Source Key Figure. In that case, there could potentially be a discrepancy between the Source Key Figure and the Target Key Figure. For some requirements, you might not want such a discrepancy. In such a cases, you could opt for the following method:

  • Method to achieve empty in Target Key Figure purely by means of Copy Operator (by 2 Key Figure Selections), even if there is no Planning Object in the Source Key Figure

If one wishes to achieve this purely by means of a Copy Operator, one can add 2 Key Figure Selections in the Copy Operator. The second being the original Key Figure Selection (from Source Key Figure to Target Key Figure). Before this Key Figure Selection, one could add another Key Figure Selection (with option "Clear Values") such that the Target Key Figure is first erased (for the same relevant periods, that is: the same periods as those of the first original Key Figure Selection).

Now the result is:

  • Due to the first step: if there was no Planning Object yet in the source Key Figure (in a sense, this is 1 interpretation of "empty"), then the target Key Figure will also be empty (cleared).
  • Due to the second original copy operator step: if there was already a Planning Object in the source Key Figure, with an empty period (NULL), then the target Key Figure will also become empty, this is default behavior of the Copy Operator.

However, please also be aware of the following information, as per the in-app IBP "Help". This relates to the "Values to be Read" selection within the "Key Figure Selection" section of a Copy Operator: