How to Delete All data from E Fact Table Inventory through program

[Former Member]

Hi Experts.

I am facing an issue.

When i am clicking on manage tab of Inventory Cube(zic_c03), it showing as program terminated error (SQL Code 21 occurred while accessing Table).

If data is problem then how to delete the all data from E Fact table through Program need logic and code.

Thanks

Sunil

[Former Member]

Hi,

Are you trying this activity in Dev or Prod?

Right click on cube and click on delete data. if this wont work follow below steps

If it is dev try to delete using Se14 and give E tables there. There you can be able to delete.

you need to be very careful because sometimes when you delete data using SE14 it will corrupt.

Thanks

[ccc_ccc]

This message was moderated.