Hello, I would be very grateful if you can help me. I am trying to install the Analysis Services Deployment Wizard. But I have no idea how to create or where to find the file with extention **.asdatabase** . My version of SQL is 2012 on Win7. I am new to SQL and need the Analysis Services for Excel Add-in Data Mining tool. Thanks in Advance
The .asdatabase is available when you run a Build on your Analysis Services project in SQL Server Data Tools. You can find it in the bin folder in the location where your project is stored. Are you doing something extra with SSAS outside of the Excel Data Mining addin? You shouldn't have to use the deployment wizard to get going with the addin. There's a little wizard in Excel that will create the DMaddin database for you.