Skip to Content
author's profile photo Former Member
Former Member

Selective deletions in Infocube and DSO

Hi Experts,

I have a requirement where our Basis is performing Re-org in BW.

For this I have to delete the data which is older than 13 months from all the data models( Cubes, DSO's) which I have list of.

Now when I delete the contents from DSO with selective deletions in fiscal year period it would delete from active data table.

I need to delete the same consistently in all the tables Change log and new data table as well.

How can I achieve this.

Selective deletion from Infocubes.

When I do selective deletion from cube it would delete from fact table. How would it delete the same selections from Dimensions.

I need to delete the same all the dimension tables and fact table and if view needs to be deleted as well.

Please advise so that I have consistent deletion.

Thanks,

Santhosh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 03, 2012 at 10:44 AM

    Hi Satish,

    Deletion Of DSO data.

    u can delete Active data table data through selective deletion.

    To delete Change log table data- create one process chain and maintain the variant.

    Manual Procedure to delete the Change log tables-

    DSO -> Environment -> Delete Change Log data, chose date and delete requests.


    No need to delete the data in New data table becoz whenever Data activated in the dso New data table will be freed by moving the data from NDT to ADT and Change log tables.

    Deletion of IC data.

    Right click on the IC-->delete data

    Then it will prompt u one dialog window.Here we get two options.

    1.Facts only

    2.Facts and dimensions

    In your case select 2nd option.

    Tcode:Delete_facts

    Once we delete the entries in Fact and Dim tables, then aggregates data also deleted.

    Regards,

    Babu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Babu,

      Thanks for the response, But I wanted to do selective deletion in the Infocube not to delete the whole content where we can delete dimensions as well.

      I have deleted the data which is 13 mnths older from now by selective deletion on fiscal year period.

      Will this be enough or do I need to even delete the data from dimensions as well.

      I think I have delete even dimension tables as well??

      Thanks,

      Santhosh

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2012 at 10:46 AM

    Selective deletion is only possible on Active Table of DSO.

    Likewise, if you delete data selectively from an InfoCube, the aggregate belonging to this InfoCube is automatically deleted.

    You receive a list of all InfoCube characteristics and can determine restrictions on these characteristics. Fact table records that correspond to these restrictions are deleted.

    Regards Ananya..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Ananya,

      I am not reloading any new data which has new structure.

      I need to clean up the data which is older than 13 months from BW hence I am trying to be deleting all the tables of the cube and DSOs.

      I cannot delete the whole content as I cannot make selections.( data older than 13 months).

      Thanks,

      Santhosh.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.