Partition of InfoCubes is done to divide the huge data in the fact table into several smaller, independent units. This improves the query performance.
InfoCube can only be partitioned using one of the two below criteria-
- Based on month (0CALMONTH info object must be present in the cube)
- Based on Fiscal period (0FISCPER info object must be present in the cube)
Partitioning and re-partitioning can be done even though the cube contains data. This concept was first introduced in SAP Netweaver BW 7.0 as a replacement of partitioning in 3.x
Please note that you do not partition the cube when you create it. Usually it is done at a later point in time when the cube has more than a million records. Continue reading →