Leveraging Performance Point Services - Microsoft Business Intelligence Tools for Excel Analysts - page 308

Follow these steps to configure a new data connection:
1. Right-click Data Connections in the Workspace Browser (the pane on the left side of the
window) and select New Data Source.
The Select a Data Source Template dialog box shown in Figure 16-3 opens.
Figure 16-3: The Select a Data Source Template dialog box.
2. Double-click the appropriate template for your data.
In this example, we select the Analysis Services template.
The Data Connections Properties window shown in Figure 16-4 appears.
3. Enter the server name, select the database name, and then click the Cube drop-down menu
to select the desired cube.
All other properties are optional (and beyond the scope of this topic).
4. Click the Test Data Source button to test the connection.
5. Click the Home tab, and then click Refresh to save your changes to the server.