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.




Related Articles :

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |