PowerPivot Management Dashboard As a Data Source
PowerPivot for SharePoint includes a robust Management Dashboard built in PowerPivot. You first saw that dashboard in Chapter 7. Another example of PowerPivot as a data source is using the metrics from that dashboard within a PowerPivot solution. However, establishing a connection to the PowerPivot workbook behind the Management Dashboard requires a slightly different process from what you just saw in the previous section. I provide an example next. As part of the example, we will use an Office Data Connection (
.odc) file to specify the data connection configuration.
Creating the Office Data Connection (.odc) File
Begin with access to the PowerPivot Management Dashboard, located within SharePoint ...