Cube GetCellNote
Retrieves a cell note.
Request
<Alea:Document xmlns:Alea="http://www.misag.com">
<Alea:Request RequestID="001" Class="Cube" Method="GetCellNote">
<Alea:CellCoordinates Cube="SALES">
<Alea:Element Dimension="TIME" Name="2009" />
<Alea:Element Dimension="VERSION" Name="Actual" />
<Alea:Element Dimension="CURRTYPE" Name="EUR" />
<Alea:Element Dimension="LEVEL" Name="IFRS" />
<Alea:Element Dimension="UNIT" Name="C1101" />
<Alea:Element Dimension="INTERCO" Name="TotalPartner" />
<Alea:Element Dimension="PRODUCT" Name="AS600/175" Hierarchy="Tire Size" />
<Alea:Element Dimension="PROFIT" Name="Revenue" />
</Alea:CellCoordinates>
</Alea:Request>
</Alea:Document>
If no hierarchy is specified for an element, the default hierarchy is used.
You can also write the request like this:
<Alea:Document xmlns:Alea="http://www.misag.com">
<Alea:Request RequestID="001" Class="Cube" Method="GetCellNote">
<Alea:CellCoordinates Cube="SALES" Elements="2009[Actual[EUR[IFRS[C1101[TotalPartner[AS600/175[Revenue" Hierarchies="[[[[[[Tire Size[" />
</Alea:Request>
</Alea:Document>
The elements and hierarchies must be presented in the native order of the dimensions inside the cube. This order can be different from the order of the dimensions in MDX / XMLA. You can check the native order using the Cube GetList function.
Answer
<Alea:Document xmlns:Alea="http://www.misag.com">
<Alea:Request RequestID="001">
<Alea:Return>
<Alea:CellNote>My Precious Cell Note</Alea:CellNote>
</Alea:Return>
</Alea:Request>
</Alea:Document>