CGetMdxGrid¶
Summary¶
Executes the supplied MDX and returns the data as a two-dimensional array.
Example¶
Dim grid
MDX = "select [Date].[Date].allmembers on 1, [Account].[Accounts].allmembers on 0 from [Finance]"
With Application.COMAddIns("Calumo.ExcelClient").Object
grid = .CGetMdxGrid(DataSource, "Adventure Works DW", MDX)
End With
Range("A1", Range("A1").Offset(UBound(grid, 1), UBound(grid, 2))).Value = grid