Skip to Content
author's profile photo Former Member
Former Member

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?



Regards

Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2014 at 10:40 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.