Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Creating a Local Cube

Office 2000 includes all the necessary pieces to create and use local cubes. A local cube functions much the same as a server-based cube. It has dimensions (complete with hierarchies) and measures. You typically store much less data in a local cube than in a server-based cube, and a local cube doesn’t include many of the capabilities of a server-based cube. For example, a local cube doesn’t include aggregations, member properties, shared dimensions, virtual dimensions, virtual cubes, partitions, or write-back tables.

Any client application that can interact with a server-based cube can also use a local cube because the client application communicates with the PivotTable Service and the PivotTable Service can communicate ...