Accessing and Analyzing Data with Microsoft® Excel > Working with OLAP Data in Excel - Pg. : Creative Edge

Table of Contents

This Book

Accessing and Analyzing Data with Microsoft® Excel

Accessing and Analyzing Data with Microsoft® Excel

Search

Contents

Acknowledgments

Ch. 1. Making Sense of Data

Ch. 2. Basic Data Analysis Techniques

Ch. 3. Analyzing Data with Microsoft Excel

Ch. 4. Analyzing Data with PivotTable and PivotChart Reports

Ch. 5. Analyzing Data with Microsoft Access

Ch. 6. Analyzing Data with the Office Web Components

Ch. 7. Introducing Online Analytical Processing

Ch. 8. Analyzing OLAP Data with Microsoft Excel

Ch. 9. Analyzing OLAP Data with Microsoft Data Analyzer

Ch. 10. Working with XML Data in Excel and Access

Ch. 11. Extending Office Data Analysis Features with Code

Ch. 12. Maintaining Data Reporting and Analysis Systems

Appx. A. Data Analysis Quick Reference

Microsoft Excel

Working with OLAP Data in Excel

PivotTable Reports and PivotChart Reports

Microsoft Access

Microsoft Office Web Components

Microsoft Data Analyzer

Appx. B. Additional Tools and Resources

About the Author

URL

Help

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