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:
- Load elements: dimension elements are loaded (flat)
- Load consolidations: hierarchical relationships between the dimension elements are loaded
- Load attributes: attribute values for the elements are loaded
|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.|
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”).