Copying data between cubes with different dimensionality

The OLAPCopyDataArea function can be used to copy data between cubes with different numbers of dimensions. For example, you can copy data from a 2D cube to a 3D cube or from a 3D cube to a 5D cube.

To copy data to a target cube that has more dimensions than the source cube, you must provide one coordinate for every extra dimension in the target cube. This coordinate must be in the correct position in the target element list. The correct position is given by the order of dimensions in the target dimension list.

The overload of OLAPCopyDataArea takes these parameters lists:

  • sourceDimensions
  • sourceElements
  • targetDimensions
  • targetElements

You must also ensure that the source dimension list and target dimension list have the same number and order of dimensions. This requires you to specify an empty string in the appropriate position in the source dimension list.