Downtime Announcement: Please note that SAP Community Wiki will be unavailable due to a system upgrade on Tuesday, August 11th between 7 and 11 AM CEST
SAP NetWeaver Business Warehouse
Child pages
  • Report RSCDS_NULLELIM - Delete fact table rows where all Key Figure values are zero
Skip to end of metadata
Go to start of metadata

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