Show All

Create an OLAP cube from relational data

The data from your OLAP cube can be returned to Microsoft Excel only as a PivotTable report, not as an external data range on a worksheet.

1. Create a query to retrieve the fields you want to use in the cube.

   How?

2. Run the OLAP Cube Wizard in one of the following ways:

   If you created the query in the Query Wizard, click Create an OLAP cube from this query in the last wizard step, and then click Finish.

   If you created the query in Microsoft Query, click Create OLAP Cube on the File menu.

3. Follow the steps in the OLAP Cube Wizard. For specific instructions, see Help in the OLAP Cube Wizard.
4. When you finish the wizard, Query prompts you to save a cube definition (.oqy) file. Type a name for this file and then click Save.

Notes

• If you specified an offline cube (.cub) file in the OLAP Cube Wizard, the .cub file is created after you click Save. Depending on the amount of data for your cube, saving this file might be time consuming. You cannot do other work in Microsoft Query until the offline cube file creation is complete.
• To base additional Microsoft Excel reports on your cube, do not return the data from your query to Excel. Instead, open the .oqy file by using the Open command on the Excel File menu.
• You can also base Excel reports on an offline cube file by setting up a data source for the file and then specifying this data source when you run the Excel PivotTable and PivotChart Wizard.
• If you think you might want to add fields to the cube from the source database in the future, be sure to save a database query (.dqy) file so that you can use the query file to change the cube.