The F Fact Table Unused/Empty Partition Management

 

Created by:	SAP
Underlying SAP report:	SAP_DROP_EMPTY_FPARTITIONS
Client-dependent:	No
Settings as variant:	Yes
Support for RecycleBin:	No
Recommended for HANA pre-migration Housekeeping:	Yes

Introduction

Each loading process of transaction data into an InfoCube generates a new request. For each request, a separate partition is created in the F fact table. When the F table is condensed into the E table of an InfoCube, the partition corresponding to this request is deleted after the condensing is successful. A partition with this name is never created again. In addition, the entry corresponding to this request is deleted in the packet dimension table. Selective deletion from the InfoCube can remove the data of the entire request without removing the accompanying partitions. Empty partitions are those that no longer contain any data records. They probably result from removing the data from the InfoCube via a selective deletion. Unusable partitions might still contain some data. However, no entry for this request is contained in the packet dimension table of the InfoCube. The data is no longer taken into consideration by reporting. The remaining partitions are created if a condenser run has not been correctly ended.

Recommendation

We recommend using the report SAP_DROP_EMPTY_FPARTITIONS to display empty or unusable partitions of the F fact tables of an InfoCube and if necessary to remove them.