| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
Create a Data Mining Dimension | Microsoft Docs |
Learn how to create a data mining dimension to browse the dimension, use it to explore the model results, or query in SQL Server Data Tools. |
10/31/2023 |
analysis-services |
data-mining |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sql2019-earlier]
[!INCLUDEdm-dep-banner]
If your mining structure is based on an OLAP cube, you can create a dimension that contains the content of the mining model. You can then incorporate the dimension back into the source cube.
You can also browse the dimension, use it to explore the model results, or query the dimension using MDX.
-
In Data Mining Designer in [!INCLUDEssBIDevStudio], select either the Mining Structure tab or the Mining Models tab.
-
From the Mining Model menu, select Create a Data Mining Dimension.
The Create Data Mining Dimension dialog box opens.
-
In the Model name list of the Create Data Mining Dimension dialog box, select an OLAP mining model.
-
In the Dimension name box, enter a name for the new data mining dimension.
-
If you want to create a cube that includes the new data mining dimension, select Create cube. After you select Create cube, you can enter a new name for the cube.
-
Click OK.
The data mining dimension is created and is added to the Dimensions folder in Solution Explorer. If you selected Create cube, a new cube is also created and is added to the Cubes folder.