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

Creating Offline Cubes

As I mentioned earlier in this chapter, Excel can create offline cube files that contain a portion of the OLAP data stored on an OLAP database server. Offline cubes can also contain nonrelational data or relational data. In these cases, when Excel creates the offline cube file, it optimizes the data for analysis using an OLAP-like hierarchy. Offline cubes are effective when you need to package a portion of OLAP data for use when you don’t have a network connection to the OLAP server. You can also create offline cube files to produce highly summarized non-OLAP data for faster performance with PivotTable reports and PivotChart reports.

There are two procedures you can use to create offline cube files in Excel. You follow one set of steps if you want to convert an OLAP cube stored in an OLAP database server to an offline cube file. You use a different procedure if you want to convert nonrelational or relational data into an offline cube file.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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