Creating a custom MDX slice

MDX can provide functionality beyond that provided by standard slices. Use of MDX to create slices can bring performance benefits and, sometimes, be simpler than using variable slices. You can convert a standard slice to a custom MDX slice. You might do this if you have reached the limits of what is possible with a standard slice. For example, if you have a cross join of several dimensions on an axis and require a calculated element that represents the total, average, or minimum or maximum of the whole axis.

To convert a standard slice to custom MDX, edit the standard slice and select Custom MDX in the Type list.

Caution: 
You cannot convert a custom MDX slice back to a standard slice.
  1. Open the report in which to create the slice. In Design mode right-click the Slices folder in the Accessories pane and select New Slice.
  2. Specify a name for the slice and, optionally, a description.
  3. Select Custom MDX as the type of slice.
  4. Select the data connection and cube on which to create the slice.