Question Re: SAC: Automatic flat file import in Technology Q&A

SAC: Automatic flat file import

jrebsamen_sto — Tue, 01 Aug 2023 16:31:14 GMT

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

Re: SAC: Automatic flat file import

N1kh1l — Tue, 01 Aug 2023 19:13:54 GMT

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/b1a98c566bc64ce78871ee3c0b559d6f.html#create-a-multi-action

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

Re: SAC: Automatic flat file import

jrebsamen_sto — Wed, 02 Aug 2023 06:49:16 GMT

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

Re: SAC: Automatic flat file import

erdempekcan — Wed, 02 Aug 2023 13:21:56 GMT

This blog might be useful:
https://blogs.sap.com/2016/11/17/sap-businessobjects-cloud-scheduling-csvxlsx-data-and-importing-new-master-data/

Re: SAC: Automatic flat file import

PRAT280 — Wed, 02 Aug 2023 13:55:22 GMT

Hi,

For re-using the flat file transformation ( data prep/mappings etc), you need to use a SAC file server. Once you have created the rules sourced from file server, the next time when you place a new file in the file server, you can refresh the previously created job and it will import the latest data. Few points to watch out

1. File server path should be same ( you can reach out to Basis to set it up)

2. The file name and structure should be same as well ( if you use a different name with same structure, it will show error)

I hope this clarifies your question

Thanks

Re: SAC: Automatic flat file import

William_Yu1 — Thu, 03 Aug 2023 02:00:50 GMT

jrebsamen_sto

Like Nikhil mentioned, put the file into file server and schedule an import job from file server would be the best solution. But just let you know, starting from 2023 QRC3 you should be able to import from a new flat file using an exiting job without redo the mapping and wrangling if the structure is identical.

https://blogs.sap.com/2023/07/11/whats-new-in-sap-analytics-cloud-release-2023.14/?source=email-global-notification-bp-new-in-tag-followed#11