Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 22nd, 2003, 05:08 PM
Registered User
 
Join Date: Jun 2003
Location: , , USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Analysis Manager

Hi everybody,

I started to study the Analyses Services component of SQL Server 2000. I am working on an XP Professional platform.

Following the onLine tutorial, I created an ODBC System Data Source, I made the connection and created a cube. Everything ran smoothly, and during the cube design I could browse the various tables of the database - only it was impossible for me to browse the data, by right clicking the cube name and selecting "Browse Data" - every time I tried, the answer was "Unable to browse the cube 'Sales'. Unspecified error"

Is it possible that I have installed an older version of the Analysis Services, with some nasty bugs in it?

Any help will be greatly appreciated.

Thanks in advance!

Pierre
  #2 (permalink)  
Old July 25th, 2003, 05:39 PM
Registered User
 
Join Date: Jun 2003
Location: , , USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi all,
I found the solution - one has to install the Service Package 3 (or 3a) on the SQL Server, and on the Analysis Services (each one needs a separate installation of the corresponding SP3 component). After that, Analysis Services can be used very nicely.
Details at
http://www.microsoft.com/downloads/d...displaylang=en


Similar Threads
Thread Thread Starter Forum Replies Last Post
Do you use Analysis Services? valiko_work SQL Server 2005 0 August 10th, 2007 05:41 AM
Analysis Services Backup jemacc SQL Server 2000 0 November 15th, 2006 12:36 PM
Further analysis migake XSLT 3 November 6th, 2006 07:13 PM
Crystal Analysis SaralaManoharan Classic ASP Professional 0 December 21st, 2005 08:36 AM
TOP N Analysis rj SQL Server 2000 1 July 13th, 2003 10:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.