Cube Edit

Performs these changes in the cube:

  • Add dimensions
  • Remove dimensions
  • Reorder dimensions

Specifies how the values and notes in the cube's cells are managed.

The function has these effects:

  • Rules are not changed but they are recompiled.
  • 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 and the target must be a base element. The cube is updated and all base 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 horizontal tabulator.

The SourceElement attribute can only be specified within the RemoveDimension tag and can be preceded by hierarchy name delimited by a horizontal tabulator. The specified dimension is removed from the cube. The new cube version is built with base values calculated from the old version of the cube where necessary, and only aggregations are calculated, not rules. For example, if you specify Total as the source element, the base values in the new version of the cube are written based on the aggregated values of the Total element of 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>