Information about Local Cubes
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.
Creating Local Cube Files in Analysis Services 2005/2008 - Problems and Solutions
Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Command December 13, 2007
Personal Data Marts
Supplement Your Microsoft Business Intelligence Strategy with the Fast Performance and Excellent ROI of Personal Data Marts November 12, 2007
Use Local Cubes to Improve OLAP Browsing Speed Performance
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.
Local Cubes in SQL Server 2005/2008 Analysis Services
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
Tim Peterson's 2003 PASS Presentation
A Flexible Architecture for Accessing OLAP Data
A Two Part Seminar on Getting Started with OLAP
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
Other Topics
The Value Added by a Second OLAP Client Tool
Essential Skills for Microsoft Business Intelligence
Knowledge Needed for Business Intelligence Success -
DTS, Analysis Services, and MDX Course
Microsoft SQL Server's Business Intelligence and Data Warehousing Tools
Local Cubes in a Business Intelligence Strategy
Retrieving Information about local cube creation in CubeSlice