Export (0) Print
Expand All
Expand Minimize

Multidimensional Data Source Dialog Box

SQL Server 2000

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.

Show:
© 2014 Microsoft