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

Deleting records with RSCDS_NULLELIM

Hi experts,

We would like to delete data with key figures as null in one cube, and we though about using the program "RSCDS_NULLELIM" (working with BI 7.3) and I would like to ask for the following questions:

a) If we want to use this program for several infocubes, we have to create different programs from RSCDS_NULLELIM? or just it adapted for all the cubes that we need?

Thank you very much for your answer!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 11, 2012 at 04:42 PM

    hi Die Gasse,

    Same program can be used for different infocubes to delete key figures which are as null. just you need to provide your cube name and other options

    The program :RSCDS_NULLELIM and has five input parameters:

    INFOCUBE:The name of the InfoCube containing the zero values to be deleted.

    PACKSIZE:The number of data records read after which a database commit should occur (default value = 10000).

    NO_BASIS:If this indicator is set, zero values are only deleted in the aggregates. They are not deleted in the BasicCube.

    SHOW_REP:If this indicator is set, the report generated to delete zero values is displayed before it is executed.

    SIMULATE:If this indicator is set, no data is deleted. However, all data is read and a log is created.

    Hope its helps you

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2012 at 04:33 PM

    Please post this type of question in the future to the BW space

    This is the BI space

    I will move this thread

    Thanks

    Tammy (Moderator)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2012 at 04:37 PM

    Hi,

    Also, I would like to ask if it deletes only the records with all key figures with "0" value because it was loaded like that, or also those records which are +X and -X = 0 (it reversal, after a Delta)?

    Thank you!

    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.