Partitions:
Each loading process of transaction data into an InfoCube generates a new request.
For each request an separate partition is created in the F fact table. When the F table is condensed into the E table of a cube,the partition corresponding to the request is deleted after the condensing has been successful and a partition with this name is never again created.
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.
o 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.
o Unusable partitions might still contain 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 with reporting. The remaining partitions are created if a condenser run has not been correctly ended.
Solution
Use report SAP_DROP_EMPTY_FPARTITIONS to display empty or unusable partitions of the F fact tables of an InfoCube and if necessary to remove.
Each loading process of transaction data into an InfoCube generates a new request.
For each request an separate partition is created in the F fact table. When the F table is condensed into the E table of a cube,the partition corresponding to the request is deleted after the condensing has been successful and a partition with this name is never again created.
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.
o 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.
o Unusable partitions might still contain 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 with reporting. The remaining partitions are created if a condenser run has not been correctly ended.
Solution
Use report SAP_DROP_EMPTY_FPARTITIONS to display empty or unusable partitions of the F fact tables of an InfoCube and if necessary to remove.
No comments:
Post a Comment