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

Working with OLAP Data in Excel

Working with OLAP Data in Excel

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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