| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
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. Query Generators can help ease of use and allow users to filter the report based on Dimension Slicers and cell values.
Contents
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
|
Example
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
