Configuring File Upload Custom Widget in SAP Analytics Cloud

[#1]

Hi,

I hope you are well. I would like to ask: How can I configure the File Upload Custom Widget in SAP Analytics Cloud to overwrite existing data instead of summing values when uploading from an Excel worksheet or CSV file?

https://blogs.sap.com/2023/11/03/how-to-upload-data-to-a-public-or-private-planning-version-using-a-...

I appreciate your assistance in advance.

[N1kh1l]

luis.parra

luis.parraSelecte the widget on canvas and If you go to the designer section of the widget on right hand side panel, you will see an JobSetting Option where you can decide the load option. See below

Once you change the settings, you should save and refresh the story for it to take effect.

Br.

Nikhil

[KannanR]

Hello Luis,

In the Import API, there is a parameter which can be used to specify the import method. By default the import method will be set to "Update", but this can be set to Update, Append or Clean and Replace. So, in your case if you are looking to overwrite the values, you should be okay with the default value of Update. But if you believe that isn't working as you expect then go ahead and try using Clean and Replace and specify the dimension scope that you want to be overwritten.

You could refer here for the API documentation,

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/ef48ba3ea79744bebf9b0...

Here is a sample message body:

{
    "Mapping": {
        "Bicycle": "Bike",
        "Shop": "Store"
    },
    "JobSettings": {
        "importMethod": "CleanAndReplace",
        "dimensionScope": [
            "Version",
            "Bicycle"
        ]
    }
}