We have created the Local Cube Information Center for the purpose of providing information about local cubes and for promoting the use of local cube technology.
Local cube technology is available when you use Microsoft's Business Intelligence tools - Microsoft SQL Server 7 or higher and PivotTable Services, which is available in Microsoft Office 2000 or higher, Visual Basic 6.0 or higher, and other Microsoft tools. Local cubes are files that contain OLAP cubes. They allow a person to use OLAP when they're not connected to an Analysis Server.
While much of the information presented here is "older", much of it is still relevent, and so remains intact. The changes in Analysis Services between 2000 and 2005 were vast, but there have not been significant changes since that time.
How to Dramatically Improve Browsing Speed Performance for Microsoft SQL Server 2005 Analysis Services
Questions and Answers about using local cubes to improve browsing speed performance
Download a Microsoft Word document containing the above two topics.
Download the Performance Demo file described in the above topics.
Use of local cube files in SQL Server 2005/2008 Analysis Services
Differences in the various ways of creating SQL Server 2005/2008 Analysis Services local cubes
Differences between CubeSlice Relational ASSL and CubeSlice OLAP ASSL
Differences between local cubes created with Analysis Services in SQL Server 2000 and SQL Server 2005/2008
Download a Microsoft Word document containing the above four topics.
Software Needed to Use Local Cubes Created with Analysis Services 2005
Session #1 - The Structure of OLAP Data
Session #2 - Finding Measures, Dimensions, Levels, and Member Properties in a Relational Database
Download CubeSlice files used with Session #2
Download local cube files used with Session #2