Principal Load Jobs processes

The objective of Load Jobs is to load cubes from a relational source. The data can be in a table or a view. Loading facts into a cube is one of the processes. Before a cube can be loaded, it must exist. To enable this, creating a cube is another process. Before a cube can be created, its dimensions must exist. Creating and loading a dimension make up another process.

The load processes are classified by job type, represented by an integer. The job type of a load job is stored in the _Jobs table.

The principal load processes by job type are:

  • Load Dimension (this also creates a dimension)
  • Create Cube
  • Load Facts

If you want to load a cube that does not exist in the OLAP database and neither do its dimensions, you need to:

  • Run Load Dimension (job type 1) for each one of the dimensions.
  • Run Create Cube (job type 2) for the cube.
  • Run Load Facts (job type 3).