A multidimensional ad hoc report is a report based on Microsoft SQL Server Analysis Services cubes. To create a multidimensional ad hoc report, open Microsoft Office Excel, select the cube data that you want to display on the report, and then format the data as a PivotTable or PivotChart report. The following steps will guide you through this process.

Note Note

The following steps are for Microsoft Office Excel 2007.

  1. Open Microsoft Office Excel.

  2. Click the Datatab.

  3. Click From Other Sources> From Analysis Services. The Data Connection Wizardis displayed.

  4. On the Connect to Database Serverpage, enter the name of the server running Analysis Services and enter credentials to access the server. Click Next.

  5. On the Select Database and Tablepage, select the database that contains the cubes. Then select the cubes that you want to include on your report. Click Next.

  6. The Save Data Connection File and Finishpage is displayed. Enter a name and description for the data connection file that is created by this wizard. Click Finish.

  7. The Import Datadialog box is displayed. Select how you want to view the cube data. You can choose to view the data in a PivotTable report or in a PivotChart and PivotTable report. For more information about these options, see the Excel online Help.

    Click OK.

  8. To add fields to the report, select the fields from the PivotTable Field Listpane.

    For more information about creating PivotTable and PivotChart reports, see the Excel online Help.