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

Regarding data deletion from info-cube

Hi Experts,

I have to delete 4 records from Info-cube . When I delete these records , It is taking lot of time . At last , I cancel job is system.

I usually go to manage and then deletion selection .

Please help.

Thanks

Devesh Babu

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2015 at 05:51 AM

    Do you have BWA indexes on the cube? If yes , uncheck the "Rebuild BWA indexes" box from deletion selection screen in the bottom. This will enable faster deletion, post deletion re-create the idexes separately.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 06:24 AM

    Hi,

    before deleting the request please make it RED then delete it.

    form the your screen shot please check with the cube object consistency in RSRV.

    Thanks,

    phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 09:41 AM

    Hi Devesh,

    First delete the unused SID's using this FM 'RSDRD_DIM_REMOVE_UNUSED'.

    After that using selective deletion option you can delete the required records from the cube.

    Regards,

    Krishna Chaitanya.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 10:48 AM

    Devesh ,

    Selection deletion will take long time as it hits each and every record while deleting . What is the filter criteria you are using to delete ?

    Try to delete using broader criteria like based on month ...etc..

    Regards,

    RKS

    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.