Select the Source Cube Dimension (Data Mining Wizard)
Applies To: SQL Server 2016
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.
Select a Source Cube Dimension
Select the dimension of the cube that will provide the source data for your mining structure.
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 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 Define Database Dimensions.