on 11-08-2011 9:28 AM
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?
Hi!
I think that must work with:
*CLEAR_DESTINATION
*DESTINATION TIME=2011.JAN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try this one:
*CLEAR_DESTINATION
*DESTINATION TIME=20110100
*WHEN *
*IS *
*ENDWHEN
*COMMIT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.