Microsoft Office Tutorials and References
In Depth Information
Under “Connect to a specific cube or table,” select the adventure Works cube as shown in
Figure 5-32 . Click Next to continue.
in the “Save Data Connection File and Finish” window (Figure 5-33 ), enter a valid file name
and choose a location to save the data connection file (*.odc).
Figure 5-33. Saving the Office Data Connection file to disk
enter a logical description and a friendly name.
Make sure to select the “always attempt to use this file to refresh data” check box.
Click the authentication Settings button to choose the type of authentication that will be used
for the data.
in the excel Services authentication Settings window (Figure 5-34 ), choose SSS – SSS iD,
provide the application iD you created in the earlier section (excelServices_SSS), and then
click OK. after returning to the “Save Data Connection File and Finish” window, click Finish to
complete the Data Connection Wizard.
Search JabSto ::