*clear_destination does not work

[Former Member]

Hello

I am having trouble getting the *clear_destination statement to work, I use (only) these 2 lines to delete all records related to january 2011:

*clear_destination

*destination TIME=20110100

but all the records with timeid= '20110100' remain in the 3 fact tables, I also added an "xdim_memberset TIME=20110100" statement at the beginning of the logic but this did not help, can anyone please help me on that?

[Former Member]

Hi!

I think that must work with:

*CLEAR_DESTINATION

*DESTINATION TIME=2011.JAN

[Former Member]

Hi,

Could you please let me know which version and SP are you using?

We have discovered recently that basic clear_destination scripts do not work in our environments. The reason is yet to be determined.

Regards,

Madis

[former_member649596]

Hi,

try this one:

*CLEAR_DESTINATION

*DESTINATION TIME=20110100

*WHEN *

*IS *

*ENDWHEN

*COMMIT

[former_member186498]

Hi,

try with

*INCLUDE SYSTEM_CONSTANTS.LGL

*CLEAR_DESTINATION

*DESTINATION TIME=%TIME_SET%

passing the time as parameter "2011.JAN" of the package.

Best regards

Roberto