Page 7 of 12PREVNEXT

Import data: Import external data into Excel 2003

Microsoft SQL Server OLAP Services is selected as a connection type, and a user name and password is entered in the Data Connection Wizard. An .odc file is created from a database. The PivotTable and PivotChart Wizard opens, and then the data is imported into Excel.

Now let's see how to create an OLAP cube connection.

OLAP (On-Line Analytical Processing) is a way to organize large business databases. OLAP databases are called cubes because they combine several dimensions, such as time, geography, and product lines, with summarized data, such as sales or inventory figures.

For this connection to work, you must have cube data to connect to, and the data must be on a SQL server database.

In the first step of the wizard, click Microsoft SQL Server OLAP Services. Then click Next.

You'll enter the server name, and if log on credentials are necessary, your user name and password. Otherwise, choose Windows Authentication.

In the third step, you select the database you want, and then select the cube you want to connect to. Then click Next.

In the final step, the .odc file is named for you (or you can give it another name). Then you click Finish.

The Select Data Source dialog opens once again, this time with your new .odc file in the list. You select the .odc file and click Open. Because OLAP data is imported only into PivotTable reports, the PivotTable and PivotChart Wizard opens. Click Finish to create the report.

Click the Play button on the left to see an animated example of creating an OLAP connection.

Page 7 of 12PREVNEXT