Difference between revisions of "Query Generators"

Line 1: Line 1:
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.
+
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.
 
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.
 
You can output the MDX for the entire query, or just a section to be used with other features as you require.

Revision as of 16:53, 23 November 2017

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.