Registered users    
MembershipMembership:
Latest New UserLatest:Tony lai kit
New TodayNew Today:11
New YesterdayNew Yesterday:13
User CountOverall:23318
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12890
Marina Roos12507
Eriq Neale2114
Stan Guinn1913
Michael Patrick1912
Robert Pearman1770
Nick Pieters1425
Stewart Brown616
william warren593
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Analysis Services (OLAP) and SBS 2003 R2
Prev Next
You are not authorized to post a reply.

Author Messages
Christophe Vuignier User is Offline
Switzerland
Member since
6/28/2006

Registered Users
Posts: 4
5/30/2007 09:05 AM  
Hello !!
 
We have a Small Business Server 2003 R2 premium with SQL 2000. 
 
We need now using OLAP on some databases, but I cannot found any resources on the net on how installing this component ? It's not installed by default.
 
And I search "step by step" tutorial for working with OLAP databases with SQL 2000. If someone know where I can find that...
 
Thank you very much in advance and sorry for my poor english.
 
Christophe Vuignier
 
PS: We really need working with OLAP, so if it's not possible to use "Analysis Services" with SBS2003, are there other solutions ?
Edwin Sarmiento User is Offline
Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133
5/31/2007 04:02 PM  
There is a folder named OLAP on the SQL 2000 CD where you can find the setup.exe. This would install SQL Server 2000 Analysis Services. Let me know if you need further assistance on designing OLAP cubes and utilizing the data mining features for business intelligence
MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA
http://bassplayerdoc.blogspot.com
Need a remote SQL Server DBA?
Christophe Vuignier User is Offline
Switzerland
Member since
6/28/2006

Registered Users
Posts: 4
5/31/2007 04:48 PM  
I found it with your help ! Thank you !

It's the first time I'll use OLAP, so I could need help :-) I'll post a separate thread if I need.

++

Chris.
Edwin Sarmiento User is Offline
Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133
6/01/2007 07:30 AM  
Great to hear you managed to install Analysis Services. One thing to note that SQL Server 2005 is a better product for business intelligence than SQL Server 2000. You have a full suite of business intelligence tools - from ETL using SQL Server Integration Services, to building cubes and utilizing data mining using Analysis Services, to reporting using Reporting Services.
MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA
http://bassplayerdoc.blogspot.com
Need a remote SQL Server DBA?
Christophe Vuignier User is Offline
Switzerland
Member since
6/28/2006

Registered Users
Posts: 4
6/01/2007 07:53 AM  
Thank you for your suggestion, but for now, we are using an ERP that does not support SQL 2005 Workgroup.. (SAP BusinessOne 2005)
It's only supporting SQL 2000 standard and higher.

++
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Analysis Services (OLAP) and SBS 2003 R2


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.3593773 seconds.   :   Terms Of Use   :   Privacy Statement