Returns the result of an MDX query as an array. This is a CSE/Array formula so must be entered into a range at once using Ctrl+Shift+Enter.
This is the fastest way to return cube results into Excel, but limits your options for altering the query. Query Generators can help ease of use and allow users to filter the report based on Dimension Slicers and cell values.
XL3GridArrayLookup( Connection, Mdx, [MemberHandling] )
|Connection||Connection number to use|
|Mdx||The query to run. Typically from a cell so that the query can be updated.|
|MemberHandling||Optional, how to output members
Here we have our MDX statement in cell A1. We select the range we want to output the results to, and type
Then press Ctrl+Shift+Enter.
Note that any cells outside of the data area return #N/A