![]() In fact when installing SQL Server 2012 the choices are either “Tabular Mode” or “Multidimensional and Data Mining Mode”. Any data changes only affect the table within the Excel workbook.ĭoes data mining support tabular models in addition to multidimensional models?ĭata mining is currently only supported on an SSAS server running in multidimensional mode. When doing data mining in Excel the data is stored inside the workbook and isolated from the source. When we use the “Clean Data” option in Excel does it update the data in database? I would need to setup a new environment to test other configurations, but I would assume the 2008 requirement is correct. The add-in wizard says it requires SQL 2008 or later, but the MSDN page says SQL 2012. Just a side note: I have not tired using the Excel 2013 add-in against a non SQL 2012 SSAS server. The Excel 2013 plug-in also uses SSAS 2008 or later. Yes, the Excel 2010 plug-in will allow you to use an SSAS instance that is running 2008 or later. The download links can be found on the right side of the page.Ĭan the data mining plug-in for Excel 2010 work with SSAS 2012? You actually want to choose the data mining add-in. In the screenshot below on the left is Detect Categories from the Analyze tab without the option and the right is the Forecast Wizard from the Data Mining Tab with the option.įor the download, from do I download DataMiningViewerClient to get started? ![]() ![]() This option is however on the “Data Mining” tab. Is there any way to deselect them all rather than having to do them one by one?įrom everything I have seen the “Analyze” tab we looked at does not have a select/deselect all option. When selecting variables, the default has them all selected. If you have more questions please let me know and I’d be more than happy to post the answers here along with the others. I discussed why data mining is useful to organizations, showed how to download and install the plug-in using Excel 2013 and then how to do a few basic things in each of the two tabs added by the installation.īelow are the questions I received during the webinar along with answers to each of them. You can also check out all the Pragmatic Works Free Training videos here. If you were unable to attend you can find the recording here. Thank you to everyone who attended my free webinar on Augwhere I talked about using the Data Mining Add-in for Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |