Microsoft Office Tutorials and References
In Depth Information
Working with SQL Server Analysis Services
Select the Calendar hierarchy in the Hierarchy drop-down menu.
Change the title to Calendar Date .
Click OK to finish configuring the filter part.
In the last Try It Out, you connect the filter part to the workbook.
Try It Out Connecting the Filter Part
To connect the filter part you just created to your workbook, follow these steps:
On the filter part, open the Edit drop-down menu and select Connections
Send Filter Values
Adventure Works Sales (which is the name you gave the Excel Web Access Web Part
displaying the workbook on the dashboard), as shown in Figure 12-24.
Select Get Filter Values From in the Connection Type drop-down menu.
Click the Configure button.