on 04-17-2014 2:29 PM
Hi,
Is it at all possible to write a script that would clear data from the fact table even with data audit switched on? We have recently switched data audit on but have lost the ability to run a 'Clear From Fact Table' package. We've written a piece of script logic that will clear a certain portion of our database but it keeps failing, we are thinking this is because we are trying to write directly to the FAC2 table.
I have attached a copy of the script logic to review.
Thanks,
Jamie
Hi Jamie,
Do you get any specific error while trying to run your script?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jamie,
You have posted to incorrect forum - have to move it to BPC MS
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.