cancel
Showing results for 
Search instead for 
Did you mean: 

Clean and replace subset of data - Measure SAC

Deb_
Participant
0 Kudos
365

Hi

For my actual data I use 2 ETLs for to different measure (unfortunately - dur to technical reasons I'm not able to use one ETL with 2 measures)

I want to use the "Clean and replace subset of data" method -

However as measures do no exist in it - the second ETL running, always deletes the first one

How can I solve that? any workaround?

or when will measure be added to the method?

thank you

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

dd5

dd5Measure would be taken from the mapping section. I do not think the second ETL should delete the first measure. ETL1 populates Measure 1 and ETL2 populates Measure 2. Clean and Replace for ETL1 should only delete Measure 1 with the dimension combination specified for clean and replace and ETL2 should only clean Measure 2 and replace Measure 2.

Br.

Nikhil

benjamin_masahud
Discoverer
0 Kudos

Hi N1kh1l,

I have tested this scenario multiple times and it seems that 'clean and replace subset of data' will wipe out the entire facts table within the specified scope of dimensions, irrespective of the ETL mapping of the measures in the import settings.

I.e. Import model consisting of {Dim1, Dim2, Dim3, Dim4} and {Measure1, Measure2, Measure3}

ETL 1 (clean and replace subset of data) - where measures are mapped only for Measure1 and Measure2

ETL 2 (clean and replace subset of data) - where measures are mapped only for Measure3

On both runs, it will wipe out all measures and replace, so the end state after ETL2 is Measure1 and 2 will be dropped.

Do you know if there is a workaround to clean and replace subset ONLY for specific measures?

Regards,
Benji