Purpose

The purpose of this page is to clarify the understanding of the program RSCDS_NULLELIM

Overview

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

Related Content

http://scn.sap.com/thread/3279022
https://scn.sap.com/thread/1874299

Related SAP Notes/KBAs

1820706  Report RSCDS_NULLELIM fails on SAP HANA
1587759  Duplicate Records in InfoCube Dimensions
1557192  BWA, Compress request, With Zero Elimination
1470209  BW report RSCDS_NULLELIM on InfoCube without time dimension
1323057  Program RSCDS_NULLELIM does nothing to BW aggregates
1224631  Program RSCDS_NULLELIM and Float-Keyfigures (Type FLTP)
 619826  Deleting zero values from fact tables