Deleting Data From Cubes

  • Hi Colleagues,

    I have 12 cubes which I have been processing every month from Jan'05 with Cube Processing Option as "Incremental". I was doing fine till Jul'05.But unfortunately,for Aug'05 I have processed one of the cubes twice and thus all the statistics are doubled for this particular cube.

    Is there anyway to delete the data from this cube which I processed for Aug'05?

    Any help please.

    Regards,

    Asif

  • My short answer would be 'not really'.  Do you have current backups of your Repository and also data directories?  If so, you could restore these and then just re-run your incremental for Aug.

     

    Steve.

  • Hi,

    There is a way but that is not good.

    Just make temporary tables for all the 12 tables used for cube .

    delete the data from 12 tables and process ur cubes again.

    hope this helps

    from

    killer

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply