• Article

Select the Source Cube Dimension (Data Mining Wizard)

Use the Select the Source Cube Dimension page to select the dimension from the cube that contains the cases you want to analyze. For example, if you are building a model that analyzes the purchasing behavior of customers based on demographics, you would select the Customer dimension, which typically contains a unique record for each customer and various attributes that represent demographics, such as gender, location, or income. Later in the wizard you will have the opportunity to add a table that is related to this case table: for example, you might add a nested table that shows which products the customer has purchased.

Note

This page will appear only if you have selected From existing cube on the Select the Definition Method page of the wizard.

Options

  • Select a Source Cube Dimension
    Select the dimension of the cube that will provide the source data for your mining structure.

Choosing a Dimension

Because you can select only one dimension for use in your model, it is important that you understand the cube structure and select the dimension that provides the best information for your model. If you are not sure which dimension to use, it might be helpful to browse the cube and review the fields and the data in them by using Dimension Designer. For more information, see How to: Browse Dimension Data in Dimension Designer.

If you are unfamiliar with dimensions in general, see Introduction to Dimensions (Analysis Services - Multidimensional Data).

For more information about the type of information that is typically contained in a single dimension, including attributes and measures that might be useful for data mining, see Dimension Relationships.

If the dimension that you choose does not contain all of the related attributes that you need to build the data mining model, you might need to modify the dimension. For more information, see Defining Database Dimensions.

Change History

Updated Content

Added a description in the first paragraph of a dimension that might be useful for creating a data mining model.

Added resources section at end providing links to more information about cube dimensions.