Returns the result of an MDX query as an array. This is a CSE/Array formula so must be entered into a range  using Ctrl+Shift+Enter.

L3GridArrayLookup is the quickest way to return cube results into Excel, but limits your options for altering the query. Query Generators enable you to filter the report based on dimension slicers and cell values.

XL3GridArrayLookup( Connection, Mdx, [MemberHandling] )

ParameterDescription
ConnectionConnection number to use.
MdxThe query to run. Typically from a cell so that the query can be updated.
MemberHandling

Optional, how to output members. Values are:

  • 0/missing - Members not displayed
  • 1 - member unique names
  • 2 - member captions

This example shows the MDX statement in cell A1. Select the range you want to output the results to, and type.

Then press Ctrl+Shift+Enter.

Any cells outside the data area return #N/A.