Skip to Main Content
PowerPivot for Business Intelligence Using Excel and SharePoint
book

PowerPivot for Business Intelligence Using Excel and SharePoint

by Barry Ralston
March 2011
Beginner to intermediate content levelBeginner to intermediate
302 pages
6h 57m
English
Apress
Content preview from PowerPivot for Business Intelligence Using Excel and SharePoint

Creating a SSAS Connection

Connecting the Data Mining Add-In to an SSAS instance involves two tasks. First, the SSAS server must be configured to work with the Data Mining Add-In. The second required task is adding the configured SSAS server connection within the Data Mining Add-In. In between those two tasks are some things that you can do to avoid common frustrations in making the connection to SSAS.

Configuring the SSAS Server

Within the Connection group of the Analyze menu, notice the No Connection label illustrated in Figure 10-14. This is an indication we have no SSAS server available to execute data mining operations. Therefore, our next step is configuring the connection between Microsoft Excel and SSAS.

Figure 10-14. Data Mining ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

Tony Smith

Publisher Resources

ISBN: 9781430233800Purchase book