SAC: Automatic flat file import

[#1]

Hello Experts,

is there one or several options to automatically upload data from a flat file into an existing data model in SAP Analytics Cloud?
I created a data model (new model type) and imported some data into it via the data management tap in the modeler. When the new data arrives next month, i would like to update the existing data.
Do i have to manually create a new import job, doing the same data preparations and mappings again, even if the flat file structure stays the same?
Which options are there to automize the import and solve this use case more efficient?

Highly appreciating your answer, best Regards!

Jana

[N1kh1l]

jrebsamen_sto

If it was not a local file you could have achieved it through Data Import Step of Multi Action. Sadly it does not support import jobs created on local file. I am not sure if you could move the file on a file server and try creating an import job and use that in Data Import Step of Multi Action.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/b1a98c566bc64ce78871e...

I would suggest that you upvote an existing request or raise an influence request to add the local file import jobs to Data Import step of multi Action (currently local file is not supported)

Hope this helps !!

Nikhil

[jrebsamen_sto]

Hello nikhil_1486,

thanks für your reply! From my understanding i need a planning license to create and run multi actions, which we don't have unfortunately. Is there another possibility with normal BI License to automate the upload from e.g. a file server?

Regards Jana