SAP Analytics Cloud Planning Copy from Upload Version to Public Version: Overwrite issue

[m_singh]

Hello, 

We are trying to copy data from a private version, where the data is uploaded using a flat file with "Data Uploader", the requirement is to overwrite the data. But when we copy it using data actions, first time it works fine as there is no data in the public version. With the second upload (the upload version is completely emptied before the upload), the data for the missing dimensions is set to 0.00 instead of just overwriting what is in the second upload:

Example:

• In first Upload and Copy to Public Works fine (as Period 01-04 and Dimensions L010 and L030 have similar data in Version _UPLOAD and in the public version EP2-2024

• In second Upload it can be seen the Data for L030 (Period 1)  and L010 (Period 4) is set to 0 although it should have ignored it. All other dimensions are correctly "overwritten" as per settings in data action.We tried with normal copy data action with overwrite as well as with Advanced formulas but with no success. Did anyone face similar issue or does anyone know how it can solved? Thank You!

[ihar_stankevich]

Hi, 

For better control end result - Advanced Formulas step is the best. 

For standard copy step it's designed behavior (in Advanced Formulas step the same setting is CONFIG.GENERATE_UNBOOKED_DATA = ON)

If you want to save existing values and overwrite only new uploaded rows use Advanced formulas step with setting: CONFIG.GENERATE_UNBOOKED_DATA = OFF

More info could be found here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/afe93e3cf1414a7b8419b...

Best regards,

[m_singh]

Hi , 

Thanks for your reply, I forgot to mention in advanced formula I had this configuration "CONFIG.GENERATE_UNBOOKED_DATA = OFF".

[ihar_stankevich]

Hi, 

then we need your DA advanced formula logic

[m_singh]

@ihar_stankevich : I had missed another Configuration Line in the advanced formula, after adding that, now the copy works fine. Thank you !