Dimension Load

image_pdfimage_print

The dimension load writes data into a dimension of the Jedox OLAP Server. For the load dimension, 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
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. Iin 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

Only for elements and attributes. 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.

update Existing elements that are not in the data source are deleted, and new elements are created. The result is the same as that of “create”, except that cubes containing the dimension are not deleted.
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.
delete Deletes all transferred elements. Elements of the data source are deleted in the dimension, all other elements remain.

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, all existing consolidations with the same child node to other parent nodes are deleted.
insertParallel Adds new consolidations. For all new consolidations, all existing consolidations with the same child node to other parent nodes in the same hierarchy are deleted.
delete Deletes all transferred consolidations.

 

Attributes mode
create

Only for elements and attributes. The dimension and referencing cube are deleted, and the dimension is created anew. 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. The result is the same as that of “create”, except that cubes containing the dimension are not deleted.
add New attribute values are created, and existing ones are overwritten if new value is not empty.
insert Adds new attributes in the order of the source. The same as “add”, except that duplicate attributes are deleted and replaced with new attributes.
delete Deletes all transferred attributes. Attributes in the data source are deleted in the dimension, and all other elements remain.

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

 

image_pdfimage_print
Was this post helpful?
NoYes (+4 rating, 8 votes)
Loading...