Skip to Content
Former Member
Dec 04, 2014 at 10:26 AM

About RSCDS_NULLELIM program to delete zeroes from Cube (bpc7.5)


Component Version : SAP EHP 1 for SAP NetWeaver 7.0

SAP_BW Sp 11

CPMBPC 7.5 Sp 7

Dear Folks & Vadim,

Went thru the above link to understand how to delete the existing zeroes from E Table (BPC 7.5) & tried the below options:

1) As we know that 'switching on zero elimination' works only with the new requests that are being compressed. Tried this & not much of a help.

2) Updated the dynamic script in DM with Zero elimination ON - this also not that much of help wrt existing zeroes

3) Referred to this note which has the info to delete all zeroes from the cube

1470209 - BW report RSCDS_NULLELIM on InfoCube without time dimension

Tried executing this program & found that this is not supported to run in background.

When executed in foreground, its running for some time now & since 48 minutes.

How much time it may take for checking for zeroes to get deleted from E table that has around 13,306,792 records.

Do I need to terminate this process or let it run for some more time?