Custom MDX -- System Center Cube

You can use custom Multi-Dimensional Expression (MDX) scripts to modify and tailor the OLAP cube to the exact specifications that meet your needs. Because Service Manager are model based, it is impossible to determine all your possible semantic needs when taking into account the wide spectrum of requirements and exact specifications for the domain-specific business needs of a particular user.

 Custom MDX makes it possible for you to define MDX scripts that will be applied to the OLAP cube to enable specific scenarios that users need to measure and instrument.

Syntax Elements

• local_cube_name : The name of the local cube.
• Cube_Location : The name and path for the locally persisted cube.
• source_cube_name :The name of the cube on which the local cube is based.
• source_cube_name.measure_name : The fully qualified name of the source measure being included in the local cube. Calculated members of the Measures dimension are not permitted.
• measure_name : The name of the measure in the local cube.
• source_cube_name.dimension_name :The fully qualified name of the source dimension being included in the local cube.
• dimension_name : The name of the dimension in the local cube.
• FROM <dim from clause>:Valid specification for derived dimension definition only.
• NOT_RELATED_TO_FACTS :Valid specification for derived dimension definition only.
• <level type> :Valid specification for derived dimension definition only.

A local cube is defined in terms of the measures and definitions that define it. There are two types of dimensions.

• Source dimensions - These are dimensions that were part of one of more source cubes
• Derived dimensions - These are dimensions that provide new analysis capabilities. A derived dimension can be a regular dimension defined based on a source dimension that is either sliced vertically or horizontally, or contains custom grouping of dimension members. A derived dimension can also be a data mining dimension based on a data mining model.

In a local cube, you can perform the following tasks:

• Eliminate dimensions that exist in the source cube
• Add or eliminate hierarchies from a dimension
• Eliminate measure groups or specific measures