A clear data step discards the selected data from a dimension or a cube. The extent to which you clear data from the cube determines whether a data load performs a full or partial refresh.
Clear Data Options
Choose one of the following options:
Set leaves of selected measures to null (NA) for selected dimension members: Clears the base-level data. Requires only a partial load and aggregation for new and updated data.
Set aggregates of selected measures to null (NA) for selected dimension members: Clears the calculated aggregates. Requires a partial load of new members and complete aggregation.
Set both leaves and aggregates of selected measures to null (NA) for selected dimension members: Clears all dimension members and data. Requires a complete load and aggregation.
Copyright © 2003, 2007, Oracle. All rights reserved.