SAC preparing data for weekly upload

[edmundyip]

Is it possible to do a sequence of calculation after file being updated in model?

I need to do weekly sales report, in which, weekly sales data needs to update and couple formula need to calculate before refreshing the story.

I would like to have those calculations stay in model so there is no need to re created them after in different stories

Any chance?

[edmundyip]

Hi Nikhil,

thanks for your advice.

For point 1, you said the transformation steps are stored for any future loads. I am able to transform the data in the initial load. But how I can trigger or apply the same data transformation into the future load?

I will definitely try suggestions 2 and 3.

Thanks a lot

Edmund

[edmundyip]

Hi William,

I tried to do in data wrangling, however, i am not able to store my steps in anywhere. Means, every week, I need/ someone need to type in those formulas again.

We have Data Action, but not sure it is the right tools to do it or not.

The calculation I am trying to put in the model as follow

Invoice_return= If ([d/type] = "OR", 1, -1)

- in the data flat file, there is a field called "Type", which indicated is the line is a positive (Invoice) or negative (return).

Revenue = Price x quantity shipped x Invoice_return

Please advise

thanks

Edmund

[N1kh1l]

edmundyip

There are couple of ways to do this.

1. Create a calculated column with the IF formula during data wrangling. The transformation steps are stored for any future loads.

2. Create a Data Action of type Advanced formula to run this calculation. The trigger will be manual and the calculation can be run after data loads.

3. Create a Multi Action with data load and Advanced formula data action steps in sequence. Refer the blog below.

https://blogs.sap.com/2022/08/12/integrating-data-import-job-into-multi-actions/

4. Create local story calculation. Flip side is the calculation is not store for future use.

-Nikhil

[William_Yu1]

Hi edmundyip,

Not sure what type of calculation you would to do, and where you plan to do the calculation ? In data wrangling, account/measure formula or via data action(need planning license)?

Best regards, William