Cube Edit

Adds or removes dimensions to or from a cube. The function specifies how the cell values in the cube are handled.

The function has these effects:

  • Rules are not changed but they are recompiled.
  • Accelerators are reattached.
  • The Alea:CachePartitionDimension and Alea:MeasureDimension properties are removed if the corresponding dimension is removed.
  • The cache of the cube is emptied.
  • The Alea:FormatDimension property is reset to an empty string if the corresponding dimension is removed.

Request

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001" Class="Cube" Method="Edit">
    <Alea:Cube Name="SALES">
      <Alea:Dimension Name="TIME" />
      <Alea:Dimension Name="PROFIT" />
      <Alea:Dimension Name="PRODUCT" />
      <Alea:Dimension Name="LEVEL" />
      <Alea:Dimension Name="INTERCO" />
      <Alea:Dimension Name="VERSION" />
      <Alea:Dimension Name="CURRTYPE" />
      <!-- the following dimension is added -->     
      <Alea:Dimension Name="CURR" TargetElement="-empty-" />
      <Alea:RemoveDimension Name="UNIT" SourceElement="C1101" />
    </Alea:Cube>
  </Alea:Request>
</Alea:Document>

The Alea:Dimension tag determines the dimension on which to perform the action. If Alea:Dimension is listed only with the Name attribute, then no action is taken on the specified dimension. All current dimensions of the cube must be referenced either by an Alea:Dimension or an Alea:RemoveDimension tag.

If the TargetElement attribute is specified, the dimension is added to the cube. The dimension must not yet exist in cube. The cube is recalculated and all values and cell notes will get the coordinate of the specified target element in the added dimension. The TargetElement attribute can be preceded by the hierarchy name, delimited by a tab character.

The SourceElement attribute can only be specified within the RemoveDimension tag. The specified dimension is removed from the cube. The cube is recalculated with the specified source element. The SourceElement attribute can be preceded by the hierarchy name delimited by a tab character. For example, if you specify Total, the cube is recalculated based on the Total element from the removed dimension.

Answer

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Return/>
  </Alea:Request>
</Alea:Document>

Error

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Error ErrorID="error_code"/>
  </Alea:Request>
</Alea:Document>