XMLADoubleCellList

This example code shows how to execute a command that results in a list of double cells:

#define EngineVersion 5.0
#define RuntimeVersion 5.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, to loop through the list of cells, use the foreach statement.