Using CellCordinates to request single cells

Inside the Request tag, one or multiple, CellCoordinates tags can specify a cell reference. Request 1 and Request 2 show the two different ways the coordinate is specified.

Request 1

The cell coordinate can be represented using the Elements and Hierarchies attributes. The Elements tag has a list of the elements of the different dimensions of the cube. They must be in the native order of the dimensions in the cube. For each dimension, a single element must be provided. The elements are separated by an opening squared bracket character ([).

The Hierarchies tag contains the list of the hierarchies the elements belong to. They are ordered and separated the same way. If the default hierarchy is used in one dimension, it can be omitted.

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="1" Class="Cube" Method="Read">
    <Alea:CellCoordinates Cube="Sales" Elements="2014[Actual[USD[IFRS[G0000[TotalPartner[T (118 mph  190 km/h)[Revenue" Hierarchies="[[[[[[Speed Rating[" />
  </Alea:Request>
</Alea:Document>

Request 2

This request shows a verbose form to request the same information as Request 1. In this case, there is a single Element tag for each dimension and the name of the dimension. The element and hierarchy are explicitly specified. The hierarchy is optional.

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="2" Class="Cube" Method="Read">
    <Alea:CellCoordinates Cube="Sales">
      <Alea:Element Dimension="PROFIT" Name="Revenue" />
      <Alea:Element Dimension="TIME" Name="2014" />
      <Alea:Element Dimension="VERSION" Name="Actual" />
      <Alea:Element Dimension="CURRTYPE" Name="EUR" />
      <Alea:Element Dimension="LEVEL" Name="IFRS" />
      <Alea:Element Dimension="UNIT" Name="G0000" />
      <Alea:Element Dimension="INTERCO" Name="TotalPartner" />
      <Alea:Element Dimension="PRODUCT" Name="T (118 mph  190 km/h)" Hierarchy="Speed Rating" />
    </Alea:CellCoordinates>
  </Alea:Request>
</Alea:Document>

If no hierarchy is specified for an element, the default hierarchy is used.

Answer

The structure of the answers to Requests 1 and 2 is the same.

If the cell is a base cell containing a numeric value or a rule-calculated value, the response is:

Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="1">
    <Alea:Return>
      <Alea:Cell>
        <Alea:Value>numeric value or a rule-calculated value</Alea:Value>
      </Alea:Cell>
    </Alea:Return>
  </Alea:Request>
</Alea:Document>

If the cell contains a consolidated value, the response is:

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="2">
    <Alea:Return>
      <Alea:Cell Flags="C">
        <Alea:Value>162203581.98987</Alea:Value>
      </Alea:Cell>
    </Alea:Return>
  </Alea:Request>
</Alea:Document>