• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 30. Retrieving Data from OLAP Se... > Saving Offline Cubes from Server Cub...

Saving Offline Cubes from Server Cubes

When connected to a server-based cube with Excel, you can save subsets of the cube’s data to local cubes on your hard disk. You can reload data from the local cubes into Excel PivotTables without connecting to the server. This pack-and-go option enables you to connect your laptop computer to the server while you are in the office, download OLAP cube data, and perform OLAP analysis sessions while on the road or include OLAP analysis as part of offsite presentations. You also can save and send local cube files to other Excel users who don’t have access to your OLAP server. Follow these steps to create an offline cube from a server cube:

Create an OLAP PivotTable as you normally would, using an OLAP server as your data source.

In the PivotTable toolbar, open the PivotTable drop-down menu and choose Offline OLAP to open the Offline OLAP Settings dialog box. (This option won’t be available unless you have one or more fields displayed in your OLAP PivotTable.)

Click the Create Offline Data File button to display the Create Cube File Wizard. The first wizard screen is an information-only screen. Click Next to proceed.

Step 2 of the wizard displays a tree of the server cube’s dimensions (see Figure 30.14). Check off the dimension levels you want to include in your offline cube. Click the plus and minus signs to expand and collapse dimension hierarchies to select different detail levels in the dimension, and then click Next.

Figure 30.14. The server cube might contain too much data for an efficient offline cube. Just check off the parts of the server cube you really need.

Step 3 enables you to select the measure fields and dimension data values from the dimension levels you chose in the previous step (see Figure 30.15). Click the plus and minus signs to expand and collapse the tree view and check off the items you want to include in the offline cube. Be sure to select at least one item from each dimension level. Click Next.

Figure 30.15. You can limit offline cube size by choosing certain measures and only some data values from the dimension levels you previously selected.

The last step is to tell Excel where to save the offline cube file. Type the filename or click the Browse button to open the traditional Windows Save As dialog box.

Click Finish to begin saving the cube file. Excel displays the Create Cube File - Progress dialog box while it is copying the data. You can click the Stop button to abort the process if it’s taking too long.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint