Slice Source Cube (Data Mining Wizard)


Applies To: SQL Server 2016

You can use the Slice Source Cube dialog box to restrict the data used to train the model. Typically a cube contains data related to many different dimensions and attributes, such as all stores, all regions, and all products. It is not practical to train a model on unlimited combinations of attributes, so you use this dialog box to choose a specific set to use in training a model.

For example, in the AdventureWorks cube, you might slice by a particular product line, region, or year, to get a portion of the data.

System_CAPS_ICON_note.jpg Note

Note that dynamic MDX functions (such as Generate (MDX) or Except (MDX)) are not supported in the Slice property for partitions. You must define the slice by using explicit tuples or member references.

For example, rather than using the range operator (:) to define a range, you would need to enumerate each member by the specific years.

If you need to define a complex slice, we recommend that you define the tuples in the slice by using an XMLA Alter script. Then, you can use either the ascmd command-line tool or the Analysis Services Execute DDL Task in Integration Services to run the script and create the specified set of members immediately before you process the partition.

For More Information: Data Mining Wizard (Analysis Services - Data Mining), Create a Relational Mining Structure

Select the dimension that you want to slice.

Select the hierarchy that you want to slice. You can choose any level of a hierarchy, but the attributes used in the model will be only at the level that you choose.

For example, if you choose the Geography hierarchy, and select Country as the level, you cannot build a model that uses City as the attributes. Conversely, if you choose City as the level of the hierarchy on which to slice, you cannot create a mining model based on Country.

Select the operator to use in building a slice expression.

For example, if you chose Geography as the hierarchy, you could select the operator = and then type “Europe” as the filter, to get cube data for Europe only.

Filter Expression
Type an expression to use as a criterion when filtering the cube on the selected dimension.

This option is not used for data mining models.

Completing the Wizard (Data Mining Wizard)
Data Mining Wizard F1 Help (Analysis Services - Data Mining)
Specify Mining Model Column Usage (Data Mining Wizard)

Community Additions