cancel
Showing results for 
Search instead for 
Did you mean: 

Clean and replace SUBSET of data import method

0 Kudos
182

Hello,

I have question regarding import method Clean and replace subset of data. When selected, there is Replacement Scope segment where you can specify subset of data for which you want to do clean and replace.

As you can see in the picture below, I wanted to create a scope for Actual version and current year, so I added dimension Calendar Year (Календарска година) but couldn`t choose specific member of that dimension. 

Can someone explain why that is?  

marija_milutinovic89_0-1720614499078.png

I also read blog Data Import Methods in Import Data Connections - S... - SAP Community where similar example was given for this import method, so I don`t understand what is the problem.

Many thanks in advance.

0 Kudos

@JefB Got it, thanks. I was just hoping that with this import method I would avoid creating new import job, since there is a segment where you can define replacement scope. I thought that is the place where you set filters for data subset, so with next refresh of the same import job only those combinations are cleaned and replaced. Now I see that`s not the case.

JefB
Active Contributor
0 Kudos
uhm, I think that is somewhat the case but it's a combination of this replacement scope (which dimensions would define the unique combinations to clear) AND your source data itself after (query) filters applied & wrangling done...
0 Kudos
Yes, I could set filter for current year in the Edit SAP BW query segment of the same import job and then choose Clean and replace subset of data import method that will check data for Version/Calendar year combinations. Great, thank you!

Accepted Solutions (0)

Answers (1)

Answers (1)

JefB
Active Contributor
0 Kudos

The import job will simply check which data you have provided in your data source (after filtering/wrangling) for that version/date combination and will clean (delete) those before uploading.

0 Kudos
Ok, so in order to achieve what I explained above, I should filter data to current year in new import job, and then choose this import method?
JefB
Active Contributor
0 Kudos
Yes indeed, it will take your filter into account.
JefB
Active Contributor
imagine your model has existing data in each month. And you launch new import job with this setting, filtered on current year but you do NOT have any data in your new filtered source for january, in this case the january that was existing in the model will stay there.