Solved

Offline OLAP cube only works in Excel 2007

Posted on 2007-11-21
1
3,313 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

770 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