Skip to Content
author's profile photo
Former Member

Selective deletion of a row from a cube

Hi Friends,

I need to delete a row from a cube through selective deletion from manage tab. I had struck while giving selecting the criteria for that deletion.

My Quesion is;

1) What criteria i need to give to delete the row apart from business related information?

2) What is data packet SID ? what i have to mention in that column?

3) What is Request id SID? what i have to mention in that column?

Please help me on the above issue.

regards,

Mahesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Oct 03, 2005 at 06:15 PM

    Hi Uma,

    If you want to delete just one exact row of data from the cube you can try to do the following. First using LISTCUBE, choose the row that you want ot delete and then list down all the char values for that row. Then use these values for the delestion selections. Selective delete cannot be undone so I guess it is good to be extra careful when making the selections.

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 06:46 PM

    Hallo

    Of xourse you do it for example from Infoprovider, right click maanage, Content (first tab) Selective deletion.

    Then you get a tab where you can schedule the job according to the selections in the tab Selective Deletion where you can set a filter for the characteristics included in the Cube.

    You can select single Characteristics vlue oder range or multiple.

    If you want to dlete a record than you have to know the key of this records. For example if you have

    customer

    company

    month

    if you select only month, then you delete all month but if you restrict to month and cusotmer than you delete the combination of them.

    Reuest sid is the identifier of the request which you see on the tab manage of the cube. you select on that and in this case you will delete all request it means all records loaded with the request.

    http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

    http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

    Mike

    Best Regards

    Mike

    Add comment
    10|10000 characters needed characters exceeded