Microsoft Office Tutorials and References
In Depth Information
Working with SQL Server Analysis Services
Enter the name of your Analysis Services server. In this example, it is SQLAS .
Keep the default Use Windows Authentication option selected. This is the authentication used
by Excel client to connect to Analysis Services. It is assumed that you have the rights to connect
to it.
Click the Next button in the wizard.
In the drop-down menu for the database, select Adventure Works DW. This is the default sample
database that ships with SQL Server 2005 Analysis Services.
Ensure that the Connect To A Specific Cube Or Table option is selected.
Select the Adventure Works cube in the list.
Click the Next button in the wizard.
Click the Browse button to save the data connection file on your server.
In the file dialog box, navigate to the Data Connections Library on the Sales Report Center you
created earlier. In this example, this library is located at http://excelserver/salesreport-
center/data connections.
Enter the filename Adventure Works.odc .
Click the Save button. (The data connection file is not saved yet — this just lets you pick your
destination location and filename.) The filename should be http://excelserver/salesreportcenter/
data connections/adventure works.odc. The server name and Report Center URL should be
specific to your deployment.
Enter a description to help users understand what this data connection provides. For this example,
type the following: This is the Adventure Works corporate data.
In the Friendly Name text box, enter Adventure Works .
Select the option to always attempt to use this file to refresh data. This ensures that Excel client
always uses the data connection file you save to the server when connecting to Analysis Services,
and that you can update the file on the server if the data connection information changes. Any
workbook that uses this file will have the updated connection information (for example, if the
server name changes after an upgrade). Your screen should look like Figure 12-20.
Click the Excel Services Authentication Settings button to set up server authentication for this
Change the authentication type to SSO.
If you are not using SSO and have Analysis Services on the same box as Excel Services, are
working with the browser on the same box as Excel Services, or have Kerberos set up, select the
Windows Authentication option.
Enter the SSO-ID you created earlier: SSO .
Your settings dialog box should look like the one shown in Figure 12-21. Click the OK button.
Click the Finish button on the wizard to create the data connection file and connect the
workbook to Analysis Services. The Web File Properties dialog box is displayed.
Search JabSto ::

Custom Search