Delete old data in BW for increase database

[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.

[Former Member]

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

[former_member206568]

You can do it in specific InfoProviders using selective deletion.

Cheers!

[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.

[former_member186445]

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

[Former Member]

data transaction on year 2014

[former_member186445]

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?