MDX Select

Contents[Hide]

The MDX Select transform is created when a SSAS cube is dragged onto the canvas from the Data Connectors structure.

1. Input

The SSAS cube structure is used as input. You can then configure the MDX Select transform to and select specific measures and dimensions.

2. Add the Transform

Steps to add the transform:

  1. Drop the cube from the Data Connector structure to the Data Cube Designer.

    Adding the MDX Select transform - Step 1
    Adding the MDX Select transform - Step 1

  2. To Edit/Configure the transform, select the transform node, and click the Configure menu.

    Opening the Configuration dialog
    Opening the Configuration dialog

3. Configure

To configure the MDX Select transform, drag and drop the measures and dimensions to the right pane. For a hierarchy dimension, only one level from this hierarchy can be selected. 

MDX Select transform configuration - Screen 1
MDX Select transform configuration - Screen 1

4. Output

The figure below illustrates the output from the MDX Select transform.

Select - Sample Output
Select - Sample Output

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri