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

[Former Member]

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?

Regards

Kumar

[Former Member]

Termination was not needed, instead timelimit got exceeded & short dump occurred.

It has deleted few records with zeroes from E table but not all.

So i may need to re-run this i think by increasing the package size.

This might help Lets c.

Regards

Kumar

[Former Member]

BW version : BW 7.01

Want to understand why the background execution of this program is not supported.

Is this a BW version limitation or its the same for all the versions ?

Regards

Kumar

[former_member186338]

Hi Kumar,

No idea, but you need to successfully run it only once After simply use Light Optimization with zero elimination...

Vadim

[Former Member]

Yes, for that one time also, becoz of the volume i think, its getting terminated after running for a while & deleting some records with zeroes

May be I need to check with basis i think to execute after working hours by increasing the time limit etc

Regards

Kumar

[former_member186338]

Yes "May be I need to check with basis i think to execute after working hours by increasing the time limit etc" - correct approach)