Import OLAP Data into a Workbook Using an Existing Query (.oqy) or Offline Data Cube (.cub) File
1. | On the Data menu, point to Import External Data and then click Import Data. The Select Data Source dialog box appears. |
2. | In the Files Of Type list, select OLAP Queries/Cube Files. |
3. | Locate and select the .oqy or .cub file you want to import, and then click Open. |
4. | In the PivotTable And PivotChart Wizard, select an option for where to place the PivotTable report that references the OLAP data, in either a new worksheet or the existing worksheet (beginning at the cell referenced in the list directly below the Existing Worksheet option). |
5. | Click Finish. The OLAP data is presented as a PivotTable report in the current workbook. |