Hi,

We have an MDX query to get the data ( columns are
calculated members) from the cube and would like to get it
in an array for further processing. Currently we use ADO
Recordset to get the data and rs.getrows to transfer to an
array. The performance is very slow. Can anyone suggest
how to improve the performance?

strSource = "SELECT { [data].[Average],[data].[10th
Percentile]," & _
"[data].[25th Percentile],[data].[75th Percentile],
[data].[90th Percentile]}" & _
" ON COLUMNS ,{ [data].AllMembers } ON ROWS " & _
.....
rs.Open strSource, conn, adOpenStatic, adLockReadOnly,
adCmdText
... array1 = rs.GetRows