Excel 2007 DataMining Add-in Database on SQL Server 2005 destroyed by using SQL Server Managment

Hello,

i have made some Data Mining Model Examples in Excel 2007 (not temporarily!). They where there after leaving an re-opening Excel. I have used them several times. Then I want to look, if I can see them also via SQL Server Managment Studio in the Analysis Services. There where nothing in the DMAddInDB in Analysis Services.

And after this, in Excel my DataMining Models have disappeared and all Models i have made since this disappeared also.

Perhaps I have destroyed the database. But will this happen every time? Can I share Data Mining Models I have made with Excel with Projects in SQL Server Analysis Services?

Thanks

Berenice

This should not happen and the persistent models created in Excel should be accessible via any other clients (Management Studio, BI Dev Studio), assuming that the permission set is correct (a model may be hidden by the fact that the current user does not have read permissions on that model, but I assume it is not the case in your situation)

Temporary models (generated by Table Analysis Tools or by explicitly selecting Temporary in the Data Mining client add-in) will disappear when Excel is closed (or when the connection is changed). Again, if you found them after re-opening Excel, this is not the case.

So, it looks like either a permissions issue or the database was accidentally destroyed/cleared

|||

I have just spoken with another customer with the same issue. However, in their case, it turned out that they had used the (default) database for their Analysis Services connection in Excel rather than selecting DMAddInDB or another named database. As a result they were not seeing the models where they expected them.

Could this be the cause here? Let us know if you have been able to reproduce the problem, Berenice.

Thanks

|||

Hello,

good hint! When leaving Excel and re-opening Excel another time the connection is established automatically with the SQL Server 2005 AS and I don′t have looked at the connection properties which where changes from DMAddInDB to default (or "Standard" in the german version).

An with this hint I have finally found the solution for another problem I have searched for today. I was not able to construct a Mining Modell on Analysis Services Database, I was not able to choose the right database/datasource. I have seen another AS Database (perhaps the default one) an could not change to another database.

When I have changed the dataMining connection to the right database as actual I could use my analysis services database.

Really helpful, thanks a lot!

Berenice