Skip to Content

deleting record from infocube

Dear Freinds,

2 years back we have loaded record in an infocube and now cube is compressed , but now we come to know that in that record one request was false.So now management want us to delete that request how to do that.???

Thank You.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 04:30 PM

    Hi

    You can perform this activity via the selective

    deletion function in Infocube maintenance. You would need to de-activate any

    aggregates, perform the selective delete, then re-activate the aggregates.

    In terms of performance, the most important thing is to re-build DBSTATS and

    check for degenerated indexes that may need re-building to bring their size

    down.

    Deleting a request ROLLED UP in aggregate => no problem (it just takes

    longer because of the activation/deactivation of the aggregates)

    Deleting a request COLLAPSED in the cube (named 'compressed' in older

    BW-versions which I'm hoping you're no longer using) => you CAN NOT

    delete this based on the request-id (since collapsing removes this) =>

    just maybe a selective delete can work for you. For this:

    => Manage Data Target-screen of your cube

    => tab Contents

    => push button 'selective deletion' (lower right)

    => on Selection choose 'immediate start' on Delete Selections

    choose your selections WISELY

    => push START (not continue)

    A selective delete : deletes data on your cube base on a selection

    However,another method can be by following these steps:

    1 find your request on request infocube manage/request.

    2. Goto Monitor screen and apply request reverse posting.

    3. so it wiil add one request with negative values.

    4. you have to compress that particular request.

    5. see your data in Bex.

    For any other functionalities for requests in InfoCubes,please refer to the following link:

    http://help.sap.com/saphelp_nw04/helpdata/EN/d4/aa6437469e4f0ae10000009b38f8cf/content.htm

    Regards

    Chen

    Add a comment
    10|10000 characters needed characters exceeded

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.