How to: Create a New OLAP Mining Structure

  • Article

You can use the Data Mining Wizard in Microsoft SQL Server 2005 Analysis Services (SSAS) to create a new OLAP mining structure in an Analysis Services project or database.

To create a new OLAP mining structure

  1. In Solution Explorer in Business Intelligence Development Studio, right-click the Mining Structures folder in an Analysis Services project, and then click New Mining Structure.

    The Data Mining Wizard opens.

  2. On the Welcome to the Data Mining Wizard page, click Next.

  3. On the Select the Definition Method page, select From existing cube, and then click Next.

  4. On the Select the Data Mining Technique page, select the data mining algorithm that you want to use, and then click Next.

    For more information about data mining algorithms, see Data Mining Algorithms.

  5. On the Select the Source Cube Dimension page, under Select a Source Cube Dimension, select the source cube dimension on which to base the mining structure, and then click Next.

  6. On the Select the Case Key page, under Attributes, select the attribute that will be the key of the mining structure, and then click Next.

  7. On the Select Case Level Columns page, under Related Attributes and Measures, select the attributes and measures that will be the case columns of the mining structure, and then click Next.

  8. On the Specify Mining Model Column Usage page, under Mining model structure, select the input and predictable columns, and then click Next.

    You can add a nested table to the mining structure using Add Nested Tables and remove nested tables using Remove Nested Tables.

  9. On the Specify Columns' Content and Data Type page, under Mining model structure, you can change the content type and data type for each column.

Note

OLAP mining models do not support using the Detect feature to automatically detect whether a column contains continuous or discrete data. For more information about content types and data types, see Content Types (Data Mining) and Data Types (Data Mining).

  1. Click Next.
  2. On the Slice Source Cube page, you can filter the data that is used to create the mining structure. For more information about how to slice a cube, see How to: Filter the Source Cube for a Mining Structure.
  3. Click Next.
  4. On the Completing the Wizard page, provide a name for the mining structure and the related initial mining model that will be created.
    If you want to create mining model dimension, select the Create mining model dimension check box and provide a name for the dimension. If you want to create a new cube that contains the new mining model dimension, select the Create cube using mining model dimension check box, and provide a name for the new cube.
  5. Click Finish.

See Also

Other Resources

Mining Structure Tab How-to Topics

Help and Information

Getting SQL Server 2005 Assistance