Skip to Content
0

Delete old data in BW for increase database

Jun 07, 2017 at 04:54 AM

57

avatar image
Former Member

How to delete old data before year 2014 in BW.

Please suggest me, What should I do?

What the information for prepared to basis.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mario Tibollo Jun 07, 2017 at 06:12 AM
0

what do you mean with 'before 2014'? all data? or some specific flow/targets?

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

data transaction on year 2014

0

again, are you talking about 1 specific flow, or do you just want to delete all the data prior to 2014 in BW?

And prior to 2014 meaning? data loaded before 2014? or doc dates?

0
Sumit Singh
Jun 08, 2017 at 09:37 AM
0

You can do it in specific InfoProviders using selective deletion.

Cheers!

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

if I want to delete data in year 2014 all InfoProvider for increase disk space in database.

Please recommend me.

Thanks in advance.

0
avatar image
Former Member
Jun 08, 2017 at 03:37 PM
0

Dear Kamonpat,

At first, you need to identify which tables are actually biggest one, this can be done in t-code ST04 depending on DB you have.

Afterwards, you can analyse data for which period is kept in this table, and depends on object type there are several ways to get rid of this data, for PSA, Changelogs it could just be cleaned up, for the InfoCubes and DSO data could be archived.

Kind regards,

Andrey

Share
10 |10000 characters needed characters left characters exceeded