Solved

Offline OLAP cube only works in Excel 2007

Posted on 2007-11-21
1
3,324 Views
Last Modified: 2008-02-01
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 ?
0
Comment
Question by:sdom100
1 Comment
 
LVL 1

Accepted Solution

by:
TimothyPeterson earned 500 total points
ID: 20340925
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question