Dimension Load

image_pdfimage_print

The dimension load writes data into a dimension in the In-Memory DB (OLAP). For the dimension load, the data source, target connection, and the name of the dimension are defined first.

The load is formed in the following three consecutive steps, which are executed when they have been activated and the appropriate data is available in the data source:

  1. Load elements: dimension elements are loaded (flat)
  2. Load consolidations: hierarchical relationships between the dimension elements are loaded
  3. Load attributes: attribute values for the elements are loaded

The settings for dimension loads are described in the table below. Jump to Advanced settings.

Main settings
Data source

The source is an extract or transform containing the dimension data. If it is a tree, the dimension can be created including consolidations and attributes. If not, only flat elements and attributes can be created. In this case, the first column has to contain the element name and the other columns may contain attributes.

Target connection Connection to a Jedox OLAP Server
Target dimension Name of the OLAP dimension. If the dimension is not present, it will be created during the load.

Elements mode

 

create

The dimension and referencing cube are deleted, and the dimension is created anew. Deletes existing elements and creates new ones in the order of the source. If the advanced option Create predefined subsets is selected, then predefined subsets will also be added to newly created dimensions.

update

Existing elements that are not in the data source are deleted, and new elements are created. The result is nearly the same as that of “create”; only the order of elements is different. New elements are added at the end of the dimension. If the advanced option Create predefined subsets is selected, then predefined subsets will also be added to newly created dimensions.

add

Adds new elements at the end of the dimension. The elements existing in the dimension before the add operation are not deleted.

insert

Adds new elements in the order of the source. The elements existing in the dimension before the insert operation are not deleted. If the advanced option Create predefined subsets is selected, then predefined subsets will also be added to newly created dimensions.

delete

Deletes all transferred elements. Elements of the data source are deleted in the dimension, all other elements remain.

inactive Elements will not be loaded.

Consolidations mode

 

update

All existing consolidations are deleted, and transferred consolidations are created. 

add

Adds new consolidations. All existing consolidations remain.

insert

Adds new consolidations. For all new consolidations, existing consolidations with the same child node to other parent nodes are deleted. The resulting dimension has only one parent for each node.

insertParallel

Adds new consolidations. For all new consolidations, existing consolidations with the same child node to other parent nodes in the same hierarchy are deleted. The resulting dimension has only one parent for each node in every parallel hierarchy.

delete

Deletes all transferred consolidations.

inactive Consolidations will not be loaded.

Attributes mode

 

 

create

Deletes existing attributes and creates new ones in the order of the source.

update

Existing attributes that are not in the data source are deleted, and new attributes are created. This option writes all attribute values in the source.

add

New attribute values are created. All existing values are overwritten if the new value is not empty/0 for string/numeric attributes.

insert

New attribute values are created. All existing values are overwritten.

delete

Deletes all transferred attributes. Attributes in the data source are deleted in the dimension, and all other elements remain.

inactive  Attributes will not be loaded.

Note: in order to load language-dependent attributes of the dimension, the names of the attributes in the tree source have to apply to the form “<attributeName>@<languageName>” (e.g. “Description@de_DE”).

 Advanced settings
Dimension type Select a dimension type (or no type) for a dimension that is created during the load.
Generate default subsets When checked, creates predefined subsets when a dimension is created during the load.
image_pdfimage_print