cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Clear From Fact Table Package

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jamie,

Do you get any specific error while trying to run your script?

Former Member
0 Kudos

Hi Nilanjan,

We only get the standard 'Object variable or With block variable not set.' error.

I'm not sure if that is of any help though. 😞

Thanks,

Jamie

former_member186498
Active Contributor
0 Kudos

Hi Jamie,
which version of bpc are you using? Which SQL version?

Regards

     Roberto

Former Member
0 Kudos

Hi Roberto,

We are using BPC version 7.5 and SQL 2008 Service Pack 3.

Thanks,

Jamie

former_member186338
Active Contributor
0 Kudos

Hi Jamie,

You have posted to incorrect forum - have to move it to BPC MS

Vadim