XMLADoubleCellList
This example code shows how to execute a command that results in a list of double cells:
#define EngineVersion 3.0 #define RuntimeVersion 3.0 * void XmlaPrintDoubleCellList(XMLAConnection connection) { string mdx = "select [MEASURES].[Sales] on 0, [REGIONS].[Europe (East/West)].[Eastern Europe].[Bulgaria] on 1, {[PRODUCTS].[Total].[Total Monitors].children, [PRODUCTS].[Total].[Total Monitors]} on 2 from TotSales"; XMLADoubleCellList result = XMLAExecuteMdxDouble(connection, mdx); string row = ""; foreach (XMLADoubleCell cell in result) { row = row + XMLAGetValue(cell) + "; "; } WriteLine(row); }
To store a list of double cells, use the
XMLADoubleCellList
data type. Then you loop through
the list of cells by using the
foreach
statement.