Microsoft introduced a cool feature in Excel 2007 called Offline OLAP that enables you to work with an Analysis Services Cube in disconnected mode. The Offline OLAP feature basically snapshots a version of the cube into a local cube file which can be used by Pivot Tables.
Some potential scenarios where the offline cube file can be really helpful:
A wizard pops up. Click Create Offline Data File button (shown in Figure 2).
The subsequent wizard steps allow you to select the dimension attributes, members, hierarchies, measures and calculated measures. By default the cube members used in the PivotTable is selected. (Figures 3 and 4) .
The final step is to save the data to a local cube file (figure 5)
To switch from offline to online mode, navigate as before PivotTableTool>>Options>>OLAP Tools>>Offline OLAP and select the On-line OLAP option which is now enabled (figure 6).
To switch from offline to online mode, navigate as before PivotTableTool>>Options>>OLAP Tools>>Offline OLAP and select the On-line OLAP option and Click Edit offline data file.
Offline OLAP is a really cool feature in certain scenarios. One improvement that I would prefer to see is some kind of visual differentiation to indicate that the PivotTable is in offline mode which is currently not available.