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

need to distribute reporting solutions to clients who do not have access to your network, or clients
for whom network access is extremely slow.
To create an offline cube, start with an OLAP-based PivotTable and follow these steps:
1. Position your cursor anywhere inside the PivotTable and, from the OLAP Tools drop-down
menu on the PivotTable Tools Analyze tab, select Offline OLAP.
2. From the Offline OLAP Settings dialog box, click the Create Offline Data File button.
3. In the Create Cube File Wizard, click Next.
4. Select the dimensions and levels you want included in your offline cube; see Figure 13-7.
Then click Next.
This is the data you want to import from the OLAP database. Select only the dimensions that
you need available to you while disconnected from the server.
The more dimensions you select, the more disk space your offline cube file takes up.
Caution
Figure 13-7: Select the dimensions and level you want included in your offline cube.
5. Filter any members or data items you do not want to include; see Figure 13-8. Then click
Next.
For example, the Extended Amount measure is not needed, so deselect that check box. This
ensures that this measure will not be imported and will not take up unnecessary disk space.