Microsoft Office Tutorials and References
In Depth Information
If the Dashboards library is not shown under Locations, select Browse for a location to add it.
Double-click the location to publish the file to SharePoint.
Enter the file name “AWExcelRpt” in the Save As dialog, and click Save.
Select Document as the content type, and click OK.
Navigate to the SharePoint documents folder, and click on the “AWExcelRpt.”
Close the new browser window and Excel.
Now that we have a spreadsheet published to SharePoint, we will add the PivotTable and PivotChart as reports
in a new page on our dashboard.
Open the Marketing.ddwx file in Dashboard Designer.
Right-click on the PerformancePoint Content list, and select New ➤ Report.
Select the Excel Services template, and click OK.
Set the name of the report to “Sales Table.”
Enter the URL for the BI Center site in the “SharePoint site” box on the report editor.
(See Figure 6-114 .)
Figure 6-114. Adding a new Sales Table report
Select the Documents library.
Select “AWExcelRpt.xlsx” file for the workbook.
Select “SalesTable” for the item name.
Note that the Dashboard Designer has already identified the Workbook Parameters:
Date and Promotions.
Copy and paste the Sales Table report in the Workspace Browser.
Rename “Sales Table – Copy” to “Sales Chart.”
Select SalesChart from the “Item name” drop-down on the Sales Chart report editor.
Save both reports and the workspace file.
Right-click on the PerformancePoint Content list, and select New ➤ Filter.
Search JabSto ::