Microsoft Office Tutorials and References
In Depth Information
prOBLeM CaSe
Connect the Sales data cube, and use powerpivot to retrieve data and populate charts.
Solution
powerpivot for Sharepoint Server brings with it a special document library called the powerpivot Gallery. to create
a powerpivot Gallery, go to the libraries and select the “add an app” option. then choose powerpivot Gallery
(Figure 5-49 ), enter a name for your powerpivot gallery, and click Create.
Figure 5-49. Creating a PowerPivot Gallery
Once the powerpivot Gallery library is created, open excel 2013 from your local machine and click on Manage
from the pOWerpivOt ribbon menu.
1.
in the powerpivot window, in Get external Data From Database, choose “From analysis
Services or powerpivot” (Figure 5-50 ).
 
Search JabSto ::




Custom Search