The Local Cube Information Center
The Local Cube    Information Center    
www.cubeslice.com      

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.

Register for an Online Demonstration

Would you like to improve the speed of your cube browsing? Would you like your users to view OLAP data offline? You can do this with CubeSlice. We can demo CubeSlice for you, using your own cubes or with our sample cubes. Sign up now for a free demo.

Cloud BI

Economical Cloud-Based Business Intelligence with Software from Microsoft, Google, Panorama Software, and SDG Computing     April 11, 2009

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

Checklists of Essential Skills for Microsoft Business Intelligence –
How You Can Leverage DTS and Analysis Services in Your Organization

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

Characteristics of Local Cubes