Include different data in an offline cube file - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Include different data in an offline cube file

Applies to: Microsoft Office Excel 2003

If you don't know whether your offline cube file (offline cube file: A file you create on your hard disk or a network share to store OLAP source data for a PivotTable or PivotChart report. Offline cube files allow you to keep working when you are not connected to the OLAP server.) was created in Microsoft Excel or Microsoft Query, consult the person who created the file.

Show Revise a cube file created in Excel

Saving a revised offline cube file can be time consuming, and you cannot do other work in Excel while the file is being saved. Start the process at a time when you do not need immediate access to other files, and make sure you have adequate disk space to resave the file.

Make sure you are connected to your network and can access the original OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.) server database that supplied the data for the offline cube file.
Click a PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.) that's based on the offline cube file.
For a PivotChart report (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.), click the associated PivotTable report (associated PivotTable report: The PivotTable report that supplies the source data to the PivotChart report. It is created automatically when you create a new PivotChart report. When you change the layout of either report, the other also changes.).
On the PivotTable toolbar, click PivotTable, and then click Offline OLAP.
Click Offline OLAP, and then click Edit offline data file.
Follow the steps in the Offline Cube Wizard to select different data for the file. In the last step, specify the same name and location as the existing file that you are changing.

Note To cancel saving the file, click Stop in the Create Cube File – Progress dialog box.

Show Revise a cube file created in Query

In Query, open the .oqy file created by the OLAP Cube Wizard, and then use the wizard to change the .cub file. You can delete and reorganize fields, but you cannot add more fields to this type of cube. For full instructions, see Help in Microsoft Query.