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