Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!!

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question