Solved

Offline OLAP cube only works in Excel 2007

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

739 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