Set up a data source that uses the Microsoft SQL Server OLAP Services driver

Microsoft Query

Show All Show All

Set up a data source that uses the Microsoft SQL Server OLAP Services driver

You can use this driver to set up data sources for both server databases and offline cube files (*.cub) that were created from Microsoft SQL Server OLAP Services databases with the Offline Cube Wizard in Microsoft Excel or that were created from relational database records with the OLAP Cube Wizard in Microsoft Query. Learn about OLAP data sources.

Note  This topic explains how to set up data sources that use the OLAP provider for the first version of Microsoft SQL Server OLAP Services (version 7.0 of MSMDCUBE.DLL). To set up data sources for later versions of this provider, you can use the Data Connection Wizard instead of Query. For additional information about setting up these data sources, see the Help for your version of Microsoft SQL Server OLAP Services.

  1. If the Create New Data Source dialog box is not displayed, click New on the File menu, click the OLAP Cubes tab, and then double-click New Data Source. Type a name for the data source in step 1 and select Microsoft OLE DB Provider for OLAP Services in step 2.

    The OLAP Cubes tab is available only when you run Query from Excel.

  2. In step 3 of the Create New Data Source dialog box, click Connect.
  3. In step 1 of the Multi-Dimensional Connection dialog box, do one of the following:

    To connect to a server database, click Analysis server, and then supply the server name, logon ID, and password for your server. For information about these and other settings for your database, see your server administrator.

    To connect to an offline cube file, click Cube file, and enter the path to the .cub file in the File box.

  4. Do one of the following:

    If you're connecting to an offline cube file, click Finish.

    If you're connecting to a server database, click Next, select the server database, and then click Finish. In step 4 of the Create New Data Source dialog box, select the name of the database cube that you want to retrieve data from.