Parallel processing for fact load

The Load Jobs processes load in parallel where they can be done in parallel. This is done by avoiding access to the same OLAP object by different processes at the same time. No two loads are carried out on the same cube at the same time. A cube is not created before its dimensions have been created. If a cube creation is requested together with loads on that cube, the cube is created before it is loaded. But operations on different cubes are executed in parallel.

The parallel load ensures that dimension operations are carried out first. These operations are followed by operations on cubes, then on cells. A cube operation is one whose target is the whole cube, such as cube creation or adding properties to a cube. A cell operation involves filling or clearing cells, such as loading facts or clearing a cube region.