Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Microsoft SQL Server 2012 Data Mining Add-ins for Office - Use with SSAS 2008 Cube

Answered Microsoft SQL Server 2012 Data Mining Add-ins for Office - Use with SSAS 2008 Cube

  • Friday, May 11, 2012 2:23 PM
     
     
    Sign In to Vote
    0

    Hi

    Trying out the Microsoft SQL Server 2012 Data Mining Add-ins for Office.

    If getting the data from a view it is possible to use the Analyze tab. If connecting to an SSAS 2008 cube functionality is not available.

    Is there a way of using the addin with the SSAS Pivot?

    Thanks

    BiF

     

All Replies

  • Friday, May 11, 2012 6:58 PM
    Answerer
     
     
    Sign In to Vote
    0

    Tasks within Analyze tab work with data that is in Excel. If you can extract data from the cube and put it in Excel, they will work.

    Many of the tasks within Analyze tab can be done on SSAS Pivot data if you use Data Mining tab, they are just a little more difficult to do there.

    What is the task that you would like to do on the SSAS Pivot?

    Tatyana Yakushev [PredixionSoftware.com]

     
  • Monday, May 14, 2012 7:31 AM
     
     
    Sign In to Vote
    0

    Hi Tatyana

    At the moment I am stepping through the microsoft examples i.e. Key Influencer, detect category. But I want to use "real" data. my data is already in a cube and I want to use the cube so I (or non technical users for that matter) can easily filter that data down.

    So the solution could be to filter in SSAS pivots and then copy and paste into an Excel table!

    BTW when I try and connect to the cube using the datamining tab .... I seem to be connecting to the views in the DMV ....

     
  • Tuesday, May 15, 2012 5:22 PM
    Answerer
     
     Answered
    Sign In to Vote
    0

    Sorry for giving you a misleading information initially. With "Data Mining" tab, you can use Analysis services data sources, but you cannot extract data from a cube. The only tool that has UI for creating mining models based on cube is BI Dev Studio (visual studio).

    Tatyana Yakushev [PredixionSoftware.com]