Child pages
  • Report SAP_DROP_EMPTY_FPARTITIONS - Locate remove unused or empty partitions of an F-fact table
Skip to end of metadata
Go to start of metadata

Purpose

The purpose of this page is to clarify the understanding of the program SAP_DROP_EMPTY_FPARTITIONS.

Overview

Report SAP_DROP_EMPTY_FPARTITIONS cleans up space in cubes where there are loads with no records
Using SAP_DROP_EMPTY_FPARTITIONS to see how many partitions there are on a cube and work for aggregates as well.  This report only works for an Oracle or DB4 DB.

How to use it?

Call transaction SE38  with program SAP_DROP_EMPTY_FPARTITIONS.

Parameters

  • Cubename:
  • Checkbox
    SHOW
    DEL_CNT
    DEL_DIM
    DO_DROP

Related Content

Related SAP Notes/KBAs

Notes describing and correcting program SAP_DROP_EMPTY_FPARTITIONS are below:

1814621  FAQ: DBIF_RSQL_SQL_ERROR short dump, ORA-14400 error
1729235  Suspected SQL_INJECTION in SAP_DROP_EMPTY_FPARTITIONS
1312735  IBM i: Errors in error handling during compression
1306747  IBM i: F fact tables contain superfluous partitions
430486  Overview/repair of F fact table of an BW InfoCube
674489  NW_SAP_BW_MIGRATION