cancel
Showing results for 
Search instead for 
Did you mean: 

Parameters in Copy operator

sourojit_pal
Participant

Hi,

Is it possible that a copy operator can copy NULL values from source to target?

If no, Is there are paramater in COPY function, that can help in nullifying the values of Target KF before the values of Source KFs are copied into it?

Regards,

Sourojit

Caterpillar
Explorer
0 Kudos

What did you find out about this? I just ran into a situation where source key figure has nulls and target key figure has data. After the copy operator, the target key figure is still showing values. They were not set to null. I don't remember it acting this way before.

Caterpillar
Explorer
0 Kudos

Never mind...I realized the issue. The source kf planning objects don't exist (even though they show in the planning view)...which made me think they were null

Accepted Solutions (1)

Accepted Solutions (1)

Alecsandra
Product and Topic Expert
Product and Topic Expert

Hi Sourojit,

What do you try to achieve? A copy operator can create NULL values with the scope to initialize planning objects if CREATE_TIMEPERIODS parameter is selected.

Best

Alecsandra

Answers (3)

Answers (3)

former_member654033
Contributor
0 Kudos

Hello Sourojit,

Ideally copy operator will take care of it. It will copy all the data from source KF including NULL and complete overwrite the target KF.

If you want to delete the target KF Values before hand to be on safer side, you have 2 options

1. New Advance copy operator with "Clear Value" option, which will be NULL target KF - this requires another copy operator hence I don't use and recommend.

2. Use Version deletion operator to delete the KF values before running the copy operator - I always use and recommend this option to clear any KF values.

I hope this helps, please let me know if you have any question.

Thanks

Girish

former_member549855
Discoverer
0 Kudos

Hello Sourojit,

Have you got the parameter to copy null value through copy operator , where source KF is having null value ?

Regards

Ganga

sourojit_pal
Participant
0 Kudos

Hi Alecsandra,

In my scenario, I am having two KFs: KF1 (Source KF) and KF2(Target KF). KF1 is initially having NULL values in some periods while KF2 is having vales in all bucket. Now if I execute copy, all the values in KF1 (including NULL) should get copied into KF2. Please tell me, if this is taken care of by default by the COPY operator? Or is it that my Copy Operator should have CREATE_TIMEPERIODS to enable copying of NULL values?