cancel
Showing results for 
Search instead for 
Did you mean: 

Data filtering in SLT system

Former Member
0 Kudos

Hi All,

We have couple of ECC tables replicated to SLT server.

For Ex: if the ECC table has 10 years of data then the same data would be available in SLT along with the new data.

We need only 3 years of data to be replicated.All records before 3 years should not be replicated.I tried to use the filter option using IUUC_REPL_Content.I created a rule assignment using an include program.But when i started the replication the filter did not work.Do i need to maintain any other settings to make the filter work.Kindly advice.

Thanks in Advance.

Regards,

Kumar

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Steve,

Please find the below details.This has been added as a include statement under Rule assignment.

if <wa_s_ce11000>-budat LT '01.01.2015'.
skip_record.
endif.

Also under Advanced replication settings do we need to maintain anything under Table settings/Trigger options and Replication logging.

Regards,

Harish

Former Member
0 Kudos

try to change the if to

if <wa_s_ce11000>-budat LT '20150101'

Former Member
0 Kudos

Can you paste the rules you created?