PowerPivot As a Data Source for PowerPivot
An existing PowerPivot for SharePoint solution can act as a data source from which related PowerPivot solutions can be created. Figure 8-1 shows an example scenario.
Because a PowerPivot for Excel solution, once deployed to PowerPivot for SharePoint, creates a SQL Server Analysis Services database, the database can be accessed by other PowerPivot solutions. This ability to serve as a data source is limited to PowerPivot for SharePoint, however, as connections to the SSAS instance behind PowerPivot for Excel are not supported in the same manner as PowerPivot for SharePoint.
Consider the following scenario: An enterprise has created two separate PowerPivot for SharePoint solutions, one for analysis of ...
Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
