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
andAlea: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>