Support for SQL Server Analysis Services

Step 1. Creating a CUB file

The first step is to create your local cube files. There are several ways you can do this.

Panorama recommends using a product called CubeSlice for creating local cube files because CubeSlice optimizes the performance of local cubes and provides a convenient user interface for selecting the portions of the Analysis Server cube you want to include. You can use CubeSlice to create a local cube that is sliced for a particular user or a particular time period. You can remove measures, dimensions, hierarchies, levels, and attributes that are not frequently used. If you are planning to share your cube with others, but there are some parts of the cube that are more confidential, those parts can be removed.

You can download CubeSlice here:

http://www.cubeslice.com/googledocs/cubeslicegdocinstall.exe

You can also create local cube files by using Microsoft Excel:

http://office.microsoft.com/en-us/excel/HP052479081033.aspx

You can use MDX or ASSL statements to create local cube files. See the SQL Server product documentation for details.

Here are the requirements for your local cube files:

The cube can be used either as a .cub file or as a .zip file. We recommend using .zip files because they are usually much smaller, quicker to upload, and allow you to upload many more files. CubeSlice automatically creates .zip files when it creates local cubes.
SQL Server Version: only local cubes created for Microsoft SQL Analysis Services 2005 are supported. Cubes created for previous versions will result in unexpected behaviors.
Size limitations: