Clean and replace SUBSET of data import method

[marija_milutinovic89]

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?  

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.

[marija_milutinovic89]

@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]

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...

[marija_milutinovic89]

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!

[JefB]

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.

[marija_milutinovic89]

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]

Yes indeed, it will take your filter into account.

[JefB]

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.