Modify the XML options for a Grid.
Option | Description |
Connection | Set the connection for the Grid |
Auto-generate MDX (default) | Anaplan XL controls the MDX for the Grid, given the selected options, hierarchies and members. |
Manual MDX | You may type your own MDX in the edit field. Using XL3Parm( Address ) allows you to substitute parts of the MDX with cells on the worksheet. |
Get MDX from Excel range | The entire MDX statement for the Grid is taken from a cell on the worksheet. |