Cube GetList

Retrieves a list of available cubes.

Request

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001" Class="Cube" Method="GetList">
    <Alea:Cubes NameFilter="SALES" detailed="true" />
  </Alea:Request>
</Alea:Document>

If the NameFilter attribute is not present or empty, all information is returned. If NameFilter is specified, it is interpreted as a regular expression. The NameFilter attribute is optional.

Use the detailed attribute to retrieve additional details about the cubes. For example, the timestamp of the last update, base values, and so on. The detailed attribute is optional. The default is false.

Answer

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Return>
      <Alea:Cubes Count="1">
        <Alea:CubeInfo Name="SALES">
          <Alea:Description>Sales Controlling</Alea:Description>
          <Alea:Dimensions Count="8">
            <Alea:Dimension Name="TIME" />
            <Alea:Dimension Name="VERSION" />
            <Alea:Dimension Name="CURRTYPE" />
            <Alea:Dimension Name="LEVEL" />
            <Alea:Dimension Name="UNIT" />
            <Alea:Dimension Name="INTERCO" />
            <Alea:Dimension Name="PRODUCT" />
            <Alea:Dimension Name="PROFIT" />
          </Alea:Dimensions>
          <Alea:Type Value="U" />
          <Alea:Loaded Value="true" />
          <Alea:Modified Value="true" />
          <Alea:Accelerated Value="false" />
          <Alea:TRS Value="off" />
          <Alea:AccessControl Value="off" />
          <Alea:HasMDAC Value="true" />
          <Alea:ErrorSuppression Value="off" />
          <Alea:BaseValuesCount Value="295392" />
          <Alea:CalculatedValuesCount Value="0" />
          <Alea:ActiveRulesCount Value="23" />
          <Alea:TimeStamp Value="1483969820" LastModified="2017-01-09T13:50:20.000" />
          <Alea:AllocatedMemoryBytes Value="8292760" />
          <Alea:MeasureDimension Name="PROFIT" />
          <Alea:FormatDimension Name="PRODUCT" />
          <Alea:CachePartitionDimension Name="UNIT" />
          <Alea:MDACCubes>
            <Alea:MDACCube Name="#SALESMDAC" />
          </Alea:MDACCubes>
        </Alea:CubeInfo>
      </Alea:Cubes>
    </Alea:Return>


Element	Description
`Alea:Type`	Returns the cube type. These are the values: D for Dimension Access Control (DAC) cube or Multidimensional Access Control (MDAC) cube. A for cube access control cube (#_TABACC). U for user cube. R for Relations Access Control (RAC) cube.
`Alea:TimeStamp`	The `Value` attribute is deprecated and should no longer be used. Use the `LastModified` attribute instead.
`Alea:Loaded`	Indicates if the cube is loaded into memory.
`Alea:Modified`	Indicates if the cube was altered since the last save.
`Alea:Accelerated`	Indicates if the former rules engine is used.
`Alea:TRS`	Indicates if transaction logging is switched on or off.
`Alea:AccessControl`	Indicates if cube access control is active or not.
`Alea:HasMDAC`	Indicates if at least one multidimensional access control cube is assigned to the cube.
`Alea:ErrorSuppression`	Indicates if an error is returned when attempting to write to a consolidated cell.
`Alea:BaseValuesCount`	Returns the number of stored values in the cube.
`Alea:CalculatedValuesCount`	Returns the number of values in the cache.
`Alea:ActiveRulesCount`	Returns the number of enabled rules.
`Alea:AllocatedMemoryBytes`	Returns the memory used for the cube.
`Alea:MeasureDimension`	Returns the name of the measure dimension. An empty string is returned if there is no measure dimension defined for the cube.
`Alea:FormatDimension`	Returns the name of the dimension used for cell formats. An empty string is returned if there is no format dimension defined for the cube.
`Alea:CachePartitionDimension`	Returns the name of the dimension used for cache partitioning. An empty string is returned if there is no cache partition dimension.
`Alea:MDACCubes`	Returns a list of MDAC cube names. The `Alea:MDACCubes` tag is empty if there is no MDAC cube defined for the cube.

Error

<Alea:Document>
  <Alea:Request RequestID="001">
    <Alea:Error ErrorID="error_code"/>
  </Alea:Request>
</Alea:Document>

Example

This is an example of an answer where the detailed attribute is false or not specified:

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Return>
      <Alea:Cubes count="1">
        <Alea:CubeInfo Name="SALES" />
      </Alea:Cubes>
    </Alea:Return>
  </Alea:Request>
</Alea:Document>