CubeSliceCopy Load


With this load type, you can copy the values from one cube slice to another in an Integrator job. It can also perform “like” operations. The new load will execute the copy operation in In-Memory DB itself, without first reading values.

Main Settings
Data Source:

The source is an extract or transform that defines in its rows the data to be written to the cube. The first columns of the source must contain the names of the dimension elements of the cube. The last column contains the value that is written in the cube cell.

Target Connection: Connection to Jedox In-Memory DB
Target Cube: Cube in the Jedox In-Memory DB
Copy mode:

copy: copies values from one cube slice to another

copyLike: copies values from one cube slice, including their distribution on the base level, to another cube slice

Read rule-based values

If set, all rule-based cell values are extracted. If the rule value has the result 0, it is extracted if “empty cells” is set to “excludeEmpty” but not if it’s set to “excludeEmptyAndZero”.

Dimension Mapping

In the Dimension Mapping table, any dimension of the cube can be assigned for each source column, and new names can be assigned to the columns. To skip a column (thus preventing it from being loaded to the cube), use the entry “”.

The dimension order remains the same as in the source and cannot be changed. The last source column is not displayed in the Dimension Mapping, as it always contains the cube cell value.

By default, if no Dimension Mapping is given, the names of the cube dimensions are entirely defined by the names of the source column names. In this case, the number of dimensions must be equal to the number of columns in the source minus 1.