Query Generators

Revision as of 11:57, 27 July 2020 by CFrance (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

New in Version 9.1, these allow you to design a report and have the generated MDX put in a cell. This is useful when you want to have the MDX reference Excel cells or Dimension Slicers. MDX: and XL3GridArrayLookup can be easier to use when XLCubed generates the report MDX for you.

The designer for these is the same as the grid designer and you can set up the same reports.

You can output the MDX for the entire query, or just a section to be used with other features as you require.

If you right click the query cell you can edit the properties so it only outputs the mdx for an axis or hierarchy.

When connecting to a report, you can set the grid axis mdx or add a member set to link tot he mdx in the workbook.