SQL Server Analysis Services
Discussions relating to MDX and other Analysis Services or OLAP questions
Announcements
FAQ - Analysis Services Information, Webcasts, Tools, Samples
Edward MelomedMSFTTuesday, December 16, 2008 11:27 PMSQL Server 2008 SP1 released
Ed LehmanMSFTWednesday, April 08, 2009 6:16 PMService Pack 1 for SQL Server 2008 is now available for customers. The Service pack is available via download at http://www.microsoft.com/downloads/en/default.aspx and is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.
Customers have no reason to wait to upgrade to SQL Server 2008 and many are already taking advantage of SQL Server 2008 as a smart IT investment. In fact, there have been over 3 million downloads of SQL Server 2008 since the RTM in August. With this Service pack, Microsoft is introducing 80% fewer changes to customer configurations compared to previous SQL Server Service Pack releases. This remarkable decrease is a testament to a revised product development process and updated servicing strategy that is focused on ease of deployment while keeping customer environments stable.
With this service pack, Microsoft has made investments to ease deployment and make management of service packs more efficient. Key improvements in SP1 include Slipstream, Service Pack Uninstall and Report Builder 2.0 click-once deployment.
· Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots thereby increasing productivity and deployment availability.
· Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release. This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability
· Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users
To download the SQL Server 2008 Service Pack 1, please click here.
For more information on SQL Server 2008, please click here.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 145

Best paractice implementing Inprices & Gross-margin measures?
SteveSun Wednesday, November 04, 2009 12:02 PM - 8148

Referenced and Many-to-many relationship
SSAS_user1 Monday, November 02, 2009 5:13 AM - 131

Hierarchy for a fact table with a composite primary key
pscorca 9 hours 51 minutes ago - 166

AdventureWorks DW 2008, cube browser different result vs Excel 2007
javiguillen 21 hours 21 minutes ago - 5118

MDX , AS 2005. Despite clearing cache, query runs faster 2nd time round - is there a secondary cache?
Guyus Thursday, November 05, 2009 11:59 AM - 498

ProcessUpdate on Dimension dropping aggregations on unrelated partitions
Abe W Wednesday, November 04, 2009 12:11 AM - 182

LastChild NonEmpty
Carmine001 Thursday, October 15, 2009 11:51 AM - 172

Do not process cube SSAS2005 64 bit from Oracle 9.2
superbluesman Tuesday, October 27, 2009 11:01 AM - 139

Analysis services processing task in ssis
safddddddddddddddddddddd 17 hours 39 minutes ago - 148

SSAS - What happens exaclty when the MDX script is loaded?
StefLausanne Wednesday, November 04, 2009 4:48 PM - 026

Organizing a fact table with a composite primary key
pscorca 15 hours 8 minutes ago - 923059

Where to find code samples for "SQL Server 2005 Analysis Services Step by Step" book?
sumitlathwal Thursday, May 28, 2009 3:38 AM - 9137

Why is all my analysis performance counter(MSAS 2008) always show no data
KevinYang2008 Thursday, October 29, 2009 2:34 AM - 097

The OLAP engine error
RickXu810512 Saturday, November 07, 2009 3:03 AM - 043

Where to find code samples for "SQL Server 2005 Analysis Services Step by Step" book?
DeanSerb Saturday, November 07, 2009 2:28 AM - 586

MDX - Rolling 2 Day Sum
LAWSQL Friday, November 06, 2009 12:47 AM - 8388

Dimension Attribute Security on SSAS 2008 Not Working, but works fine on 2005
Darryl F Wednesday, September 09, 2009 10:51 AM - 3110

SSAS Cache PerfMon Counters
SHIF Thursday, November 05, 2009 1:53 PM - 158

Calculate Times in Measures?
AkbaJen Friday, November 06, 2009 8:50 AM - 260

calling a stored procedure from a dimension named query
CengoGS Friday, November 06, 2009 8:01 PM


