The purpose of this page is to clarify the understanding of the program SAP_DROP_EMPTY_FPARTITIONS.
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.
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