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:CachePartitionDimensionandAlea:MeasureDimensionproperties are removed if the corresponding dimension is removed. - The cache of the cube is emptied.
- The
Alea:FormatDimensionproperty 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>