Microsoft Office Tutorials and References
In Depth Information
Working with SQL Server Analysis Services
Try It Out Creating a Data-Bound Dashboard
To create a data-bound dashboard for your workbook, follow these steps:
Open the browser and navigate to the report library in the Sales Report Center.
In the New drop-down menu, select Dashboard to create a new dashboard page.
On the New Dashboard page, enter the AdventureWorks filename for the dashboard.
Enter the title Adventure Works Sales and optional description.
In the Dashboard Layout section, select the One Column Vertical Layout option.
Ensure that the option to create a KPI list automatically is select (this is the default).
Click OK to create the dashboard. Next, you add the workbook you just created to this dashboard.
Click the Open Tool Pane link on the Excel Web Access toolbar.
Click the button to the left of the workbook text box to open the asset picker. Navigate to the
report library and select the workbook you created in the previous section, Adventure Works
Sales.xlsx, and click OK.
Uncheck the Autogenerate Web Part Title option.
For the Type Of Toolbar, select None.
Expand the Appearance section and enter Adventure Works Sales in the Title field.
Click OK at the bottom of the tool pane to add the workbook to the page.
In the next Try It Out, you create a new KPI. This time, you use the Analysis Services cube as your data
source, and connect directly to a KPI defined in the Adventure Works cube.
Try It Out Connecting to a KPI
To create a new KPI and connect it to the cube, follow these steps:
In the KPI Web Part, select Indicator From SQL Server 2005 Analysis Services in the New
You must select a data connection file to connect the KPI with the Adventure Works cube. To
do this, click the icon to the right of the Data Connection text box to open the asset picker. This
opens the DCL. Select the Adventure Works data connection that you created earlier and click
the OK button.
Keep the All KPIs selected as the display folder, and select Internet Revenue from the KPI list, as
shown in Figure 12-23.
Enter the name Internet Revenue for the KPI.
Click the OK button at the bottom of the page to create the indicator.