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).