• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 30. Retrieving Data from OLAP Se... > Creating an OLAP Data Source Definit...

Creating an OLAP Data Source Definition

Microsoft provides the offline database drivers with Office 2003 to connect to SQL Server OLAP cubes. The first step in connecting to cubes is to define a data source connection. After it is defined, you can reuse data source connections in future Excel sessions. You must define a data source connection for each OLAP source you intend to use in Excel. To do so, follow these steps:

Choose Data, Import External Data, New Database Query to open the Choose Data Source dialog box shown in Figure 30.4.

Figure 30.4. This is the same dialog box you use to create a query with the Query Wizard or Microsoft Query.

Click the OLAP Cubes tab, select <New Data Source> in the list, and click OK to open the Create New Data Source dialog box (see Figure 30.5).

Figure 30.5. Give your OLAP data source any name you want, and then select which type of OLAP server you want to use.

Type a name for your new data source. In the future, you will select this name from the Choose Data Source dialog box to connect to the data source.

Select an OLAP provider from the drop-down list. To connect to Microsoft SQL Server 2000 OLAP cubes, select Microsoft OLE DB Provider for OLAP Services 8.0.

Click the Connect button to open the Multidimensional Connection dialog box (see Figure 30.6).

Figure 30.6. The Analysis Server option accesses cubes in Microsoft SQL Server 2000; the Cube File option accesses offline cubes stored on your hard disk.

Click the Analysis Server radio button. Type the server name, your user ID, and password in the spaces provided. Click Next.

Select the OLAP database from the list of available databases and click Finish to return to the Create New Data Source dialog box.

Select the desired cube from the drop-down list of cubes in the database you connected to in the previous step. Select the check box at the bottom of the Create New Data Source dialog box if you want to save your user ID and password as part of the data source definition—keep in mind that this might pose some security risk.

Click OK to save the OLAP data source definition and return to the Choose Data Source dialog box.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint