Deleting records with RSCDS_NULLELIM
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!!
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