Skip to Content

Unable to delete unused entries from Dimension Table

Hi All,

I have a requirement to remove an unused master data entry but when I try to delete it from master data it shows that that particular record is used in a cube.Even after selectively deleting that specific record from the cube, I am not able to delete the master data and the same error occurs. I have tried RSRV to remove unused data in Dimension table but correcting this issue is not working.

Can anybody give an alternative to delete this master data.

- I have tried to delete unused entries through FM:RSDRD_DIM_REMOVE_UNUSED, still no luck.

Thanks in advance,

Regards,

Deepak B.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 03 at 07:03 AM

    Hi Deepak,

    The easiest way will be to empty the cube (if you can afford it).

    The most diffcult will be to analyze why the RSDRD_DIM_REMOVE_UNUSED is not working in your case (debug ?).Are you sure you remove all the associated records in the fact tables (E and F) ?

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • May 03 at 07:22 AM

    Hi Frederic,

    Thanks for your quick reply, I found out that RSRV was not deleting as the cube was in "Planning Mode". Now I am having a different issue that I am not able to delete a master data as it says that the particualr record is being used in Line item dimension of a cube, But when check the cube there are no such records. Is there any way to delete it?

    Thanks in advance,

    Regards,

    Deepak B.

    Add comment
    10|10000 characters needed characters exceeded