Remove No-Value data from DSO objects
There are two possible cases for Non-Value data to reside in your DSO objects:
- DSOs that hold data but not being uploaded for a long time
- DSOs that hold data and being uploaded regularly but not being used in reporting
Although in both cases it doesn’t unequivocally means that the data should be removed, they are worth to know about and keep such cases under control. With the help of 4C™ SAP® BW alert pack you can easily identify and track these situations, deciding how to treat them. Working with dozens of BW clients, while using 4C™ SAP® BW we help to keep BW database in a clean state.
DSOs that hold data but not being uploaded for a long time
In example below, there is an alert, presenting the list of DSO objects and their last upload date. You can sort the report by the “Last Upload Date” column, observing which DSOs are never being uploaded or being uploaded long time ago. Such DSO objects are potential candidates for data deletion
DSOs that hold data and being uploaded regularly but not being used in reporting
In a picture below, there is an alert output, showing the list of DSO objects, uploaded on a daily basis. One of them however, was used in reporting for the last time at 13.12.2011. This DSO is a potential candidate for data deletion.