Skip to Content
avatar image
Former Member

Delete old data in BW for increase database

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 07, 2017 at 06:12 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2017 at 09:37 AM

    You can do it in specific InfoProviders using selective deletion.

    Cheers!

    Add comment
    10|10000 characters needed 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.

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

    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

    Add comment
    10|10000 characters needed characters exceeded