XL3GridArrayLookup
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.
Contents
[hide]Syntax
XL3GridArrayLookup( Connection, Mdx, [MemberHandling] )
Parameters
Parameter | Description | ||||||
---|---|---|---|---|---|---|---|
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
|