Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use the SAP incremental import function". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn how to use the SAP incremental import function.

There are 8 lines of data initially imported into Model:

Prepare to import incremental data:

Create a new incremental record in the local csv file (2020-3-13):

Rename it to formatted2-delta1.csv and import the system:

Click on the draft sources to make sure there is no issue in the Model Requirements.

Import Method selects Update. If Append is selected, it will simply add all the contents of the second uploaded csv file to the end of the model.

From the prompt message, the old 8 records in model were deleted, and the new 9 records came in, which can be regarded as the incremental import function.

Then open the story created based on this model, where the data displayed in the Bar chart has been automatically refreshed, and I can see the data on March 13th:

But line chart and pie chart still don't refresh automatically:

Graphs that are not automatically refreshed are all related to LeadNumber, the measure, and the value is always the first version of the csv file that is loaded when model initializes.

I think it is the measure of LeadNumber, which is not automatically refreshed after each import.

So I used a workaround: in the icon that failed to refresh automatically, manually create a Calculation measure with the type aggregation,operation as count dimension, and aggregation dimensions select leadID:

The automatic refresh of Line chart takes effect:

Choose LeadNumber, there is no reaction.

Use Count dimensions instead:

The incrementally imported data also takes effect:

At this point, I believe you have a deeper understanding of "how to use the SAP incremental import function". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.