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