(v24) MDX Select

MDX Select

This applies to: Managed Dashboards, Managed Reports

The MDX Select transform is created when a cube from an OLAP database (e.g., Microsoft SQL Server Analysis Services) is dragged onto the canvas from its data connector.

Input

Configure an MDX Select transform to select specific measures and dimensions to return a table of data. This tabular result becomes an input to your data cube in Symphony.

Add the Transform

Expand the data connector in the Data Connectors folder in the Explore window, then drag one of its cubes to the canvas.

Configure the transform by selecting the transform and clicking Configure in the toolbar.

Configure

To configure the MDX Select transform, drag and drop the measures and dimensions to the right pane.

For a dimension hierarchy, only one hierarchy level can be selected. Use the Hierarchy Level Display Property drop-down to indicate whether you want the captions (display values) or the unique names (keys) of the hierarchy's members.

Click the Submit button at the bottom of the dialog when finished.

Output

Open the Data Preview window to view the output.

For more information, see:

• Manual Select

• Using Transforms

• Data Cubes

• Connect to OLAP Data and Apply a Formula

• The Managed Dashboards Data Model