Skip to Content
0
Former Member
May 31, 2013 at 09:31 AM

How delete all the BW data in pre-production system.

199 Views

Hi,

We have scenario where the production source system is copied into pre-production source system, so we need to delete all BW data in BI pre-production system and reload the data again.

Please can some one help with possible options to delete all data without much of manual activity.

We have a program which deletes only PSA and DSO data.

1) Is there any ways we can delete the entire initialisation request.

2) Is there any ways we can delete the entire data in all cubes

3) Is there any ways we can delete the entire master data.

4) Is there any other best practice available for BW system if the source system is refreshed.

Thanks,

Shak.