Skip to Content
0

Unable to delete unused entries from Dimension Table

May 03 at 05:23 AM

29

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Frédéric Cincet May 03 at 07:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Deepak B May 03 at 07:22 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded