Solved

Offline OLAP cube only works in Excel 2007

Posted on 2007-11-21
1
3,340 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

615 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