Multidimensional Data Source Dialog Box
Use this dialog box to define a new multidimensional data source for a new linked cube. This new data source must use an existing Microsoft® SQL Server 2000™ Analysis Services database on an Analysis server, and you must have access to the database. You can provide access by including your user name in the OLAP Administrators group for the linked cube's publishing server or by including it in a cube role for the source cube.
For more information about data sources, see Data Sources. For more information about access requirements for linked cubes, see Linked Cubes.
This dialog box appears when in the Linked Cube dialog box, you click New Data Source.
Options
Server
Type the name of the Analysis server to which you want to connect.
Note You cannot connect to an Analysis server by specifying its IP address.
Database
Select the database that contains the source cube you want to use for the new linked cube.
Advanced
Click to display the Data Link Properties dialog box. Use this dialog box to specify special options to connect to the linked cube's publishing server.
Test Connection
Click to verify your connection to the linked cube's publishing server and source cube.