Analyze Data Mining Exception!!

Question

I have a sample XLS data, when i try to Analyze-->detect categories I get the following error in my Excel 2007:


Error (data mining) Session Mining objects (including special data source views used to 2 process data mining dimensions) cannot be created on this instance

I have SqlServer 2008 Ananlysis Server Running

Answer 1

Unchecked the Use Session Models in the Trace Dialog, can someone explain what was going on?

Answer 2

 

Here is what happens:

The Table Analysis Tools are designed to work by default with session mining models, objects that are destroyed as soon as the connection is closed. Typically, a Table Analysis Tools session will result in multiple mining models that are not useful once a task completes. The Server Configuration tool coming with the add-ins configures your Analysis Services server to allow creation of Session mining models.

 

The check box you found (and used) is intended for persisting interesting models built by Table Analysis Tools for further analysis. It is great that you used it and solved your problem. However, you should not use it too often, but rather run the Server Configuration tool and allow creation of session mining models. Otherwise, the server will be overloaded with many temporary models generated by the Table Analysis.