Data Mining Add-ins Error
When using Microsoft SQL Server 2012 Data Mining Add-ins you may encounter the below error:
Error (Data mining): Session mining objects (including special data source views used to process data mining dimensions) cannot be created on this instance
The reason this occurs is that the Data Mining tool needs to create session mining models in SQL Server Analysis Service (SSAS). By default this is set to false and needs to be set to true.
1. Launch Management Studio and connect to SSAS.
2. Right click the server and select properties which will display the below screen.
3. Set the value of Data Mining \AllowSessionMiningModel to true.
The issue is now resolved and you do not have to restart the SSAS service.