Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-18 The MDX editor in the Table Import Wizard.
The first interesting feature is the measure group selector. The measure group selector allows
you to select a measure group from which you want to load data. It is very useful because,
if the cube contains several dimensions, not all of which are linked to all measure groups,
selecting a specific measure group hides all the dimensions that are not linked to that
measure group. If, for example, you select the Sales Target measure group, (see Figure
5-19), all the dimensions that are not related to the sales targets are hidden, to make it
easier to build the query by reducing the number of dimensions.
FIguRE 5-19 The measure group selection automatically filters unrelated dimensions.