Offline OLAP cube only works in Excel 2007

Hi,
I need to create an offlien OLAP cube to distribute to some partners.
I though that this would be an industry standard format ?
Have successfully used Excel 2007 to access my SQL Server 2005 Anlysis Services cube and create an offline version - however this can only be re-opened in Excel 2007. If i try and open in 2003 (on a machine without sql server etc on) then i get an error.

Is there an industry standard ?
Am i going about this in the right way ?
sdom100Asked:
Who is Participating?
 
TimothyPetersonCommented:
Using Excel 2003, you can browse an offline OLAP cube (local cube file) created with Analysis Services 2005 and Excel 2007, but you have to install some extra software first. Here are the details:

1. Excel 2007 can use local cubes created with Analysis Server 2000 or 2005.
2. Excel 2003 can use local cubes created with Analysis Server 2000.
3. Excel 2003 can use local cubes created with Analysis Server 2005, but you have to install some extra software - the SQL Server 2005 Analysis Services 9.0 OLE DB Provider, which is available free from Microsoft.
4. Make sure you use the February 2007 version (or later) of this software. If you use an earlier version of the software, you will not be able to use local cubes created with Analysis Server 2005 SP2.

You ask if there is an industry standard format for offline OLAP cubes. Local cubes are one of Microsoft's Business Intelligence tools. They can be created by Microsoft Excel or by a Create Global Cube command, but you can have more control by creating them with an ASSL (Analysis Services Scripting Language) script. Local cubes can be browsed by most OLAP client tools that can browse Microsoft Analysis Server cubes - as long as you have the most current copy of the SQL Server 2005 Analysis Services 9.0 OLE DB Provider.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.