Browsing Analysis Services OLAP Cubes with Excel - Microsoft Business Intelligence Tools for Excel Analysts - page 254

Figure 13-8: Deselect any members you do not need to see offline.
6. Specify a name and location for your cube file. Click Finish when you're done.
The file extension for all offline cubes is .cub . In Figure 13-9, the cube file is named
MyOfflineCube.cub , and it's placed in your chosen directory.
Figure 13-9: Specify a name and location for your cube file.
After a few moments of crunching, Excel outputs your offline cube file to your chosen directory.
Double-click the file and the Excel workbook opens that is linked to the offline cube via a PivotTable.