Microsoft SQL Server Analysis Services 2005/2008 news, announcements, publications

Jan 16, 2012 - Microsoft released Cumulative Update package 3 (CU3) for SQL Server 2008 Service Pack 3

webadmin@ssas-info.com (SSAS-Info.com) — Tue, 17 Jan 2012 02:54:55 +0000

On Jan 16, 2012 - Microsoft released Cumulative Update package 3 (CU3) for SQL Server 2008 Service Pack 3

Cumulative update package 3 for Microsoft SQL Server 2008 Service Pack 3 (SP3) contains hotfixes for issues that were fixed after the release of SQL Server 2008 Service Pack 3.

Note This build of this cumulative update package is also known as build 10.00.5770.0.

List of fixes related to SQL Server Analysis Services 2008 SP3:

SQL Bug Number	KB Article Number	Description
834622	2531172	FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services
834641	2638932	FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008
834220	2660492	FIX: "Internal error" message when you run an MDX query in SQL Server 2008 Analysis Services

Please also check related updates: Cumulative Update package 8 (CU8) for SQL Server 2008 Service Pack2

Dec 20, 2011 - Microsoft released Cumulative Update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1

webadmin@ssas-info.com (SSAS-Info.com) — Wed, 21 Dec 2011 02:23:13 +0000

On Dec 20, 2011 - Microsoft released Cumulative Update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1

Cumulative update packages contain hotfixes for the Microsoft SQL Server 2008 R2 Service Pack 1 (SP1) issues that have been fixed since the release of SQL Server 2008 R2 SP1.

Note This build of this cumulative update package is also known as build 10.50.2796.0.

List of fixes related to SQL Server Analysis Services 2008 R2 SP1:

SQL Bug Number	KB Article Number	Description
738050	2562753	FIX: Slow performance when an MDX query uses unary operators on parent/child hierarchy members in SSAS 2008 R2 if you define a scope calculation on these members and if the query accesses multiple dates in a time dimension
812723	2626637	FIX: DRILLTHROUGH statement does not work if it is run against some attribute members whose values contain one or more double quotation marks in SSAS 2008 R2
804578	2629168	FIX: Internal error when you update a cellset that is returned after you run a query against a perspective in SSAS 2008 R2
827315	2638216	FIX: Error message when you run a query that uses an MDX reserved keyword as a parameter name in SSAS 2008 R2
834224	2652582	FIX: "Invalid authorization specification" error message when you run the SQL Server 2008 R2 Analysis Services Deployment Wizard by using the SQL Server Authentication mode

Please also check related updates: Cumulative Update package 11 (CU11) for SQL Server 2008 R2

Nov 17, 2011 - Microsoft released SQL Server 2012 Release Candidate 0 (RC0)

webadmin@ssas-info.com (SSAS-Info.com) — Thu, 17 Nov 2011 23:01:44 +0000

Nov 17, 2011 - Microsoft released SQL Server 2012 Release Candidate 0 (RC0).

Download here...

List of what is new in Analysis Services: http://msdn.microsoft.com/en-us/library/bb522628(v=SQL.110).aspx

Oct 18, 2011 - Microsoft released Cumulative Update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1

webadmin@ssas-info.com (ssas-info.com) — Tue, 18 Oct 2011 20:10:54 +0000

On Oct 18, 2011 - Microsoft released Cumulative Update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1

List of fixes related to SQL Server Analysis Services 2008 R2 SP1:

SQL Bug Number	KB Article Number	Description
768890	972777	FIX: The SQL Server 2008 Analysis Services and SQL Server 2008 R2 Analysis Services service stops responding when you run an ALTER command on a database while an UPDATE CUBE statement is running on the database
783501	2562396	FIX: Exception when an MDX query uses the Crossjoin function in SSAS 2008 R2 if more than 4 billion tuples are returned
783511	2588016	"Internal error: An unexpected exception occurred" error when you run the ProcessUpdate command if you modify the aggregation design of a dimension in SSAS 2008 R2
783500	2588047	FIX: MDX query incorrectly returns a NULL value in SSAS 2008 R2 if a linked cube contains a many-to-many dimension and a distinct count measure group
783513	2590200	FIX: "The results of the current statement cannot be stored on the server" error when UpdateCells commands concurrently perform many writeback operations in SSAS 2008 R2
794998	2619924	FIX: SQL Server 2008 R2 SP1 does not update Microsoft.AnalysisServices.SharePoint.Integration.dll module
797720	2624056	FIX: Status window does not have text for the process progress when you process SSAS 2008 R2 objects in BIDS or SSMS

Please also check related updates: Cumulative Update package 10 (CU10) for SQL Server 2008 R2 and Cumulative Update package 1 (CU1) for SQL Server 2008 Service Pack 3

Oct 10, 2011 - Microsoft released Cumulative Update package 8 (CU8) for SQL Server 2008 Service Pack 1

webadmin@ssas-info.com (ssas-info.com) — Mon, 10 Oct 2011 21:37:03 +0000

On Aug 17, 2010 - Microsoft released Cumulative Update package 8 (CU8) for SQL Server 2008 Service Pack 1

Cumulative update packages contain hotfixes for the Microsoft SQL Server 2008 Service Pack 1 (SP1) issues that have been fixed since the release of SQL Server 2008 SP1.

Note This build of this cumulative update package is also known as build 10.00.2775.0.

List of fixes related to SQL Server Analysis Services 2008:

SQL Bug Number	KB Article Number	Description
421044	979778	FIX: You receive an error message when you run a query that uses a parent/child dimension in SSAS 2008
426636	981838	FIX: An MDX query returns an incorrect result when you run the query by using a clean cache in SSAS 2008
427277	981899	FIX: An exception occurs when you filter or run an MDX query on a database that contains a dynamic set
443051	982321	FIX: Error message when you process an index of a partition in SSAS 2008
444225	982418	FIX: "An unexpected error occurred" error message when you use the OPENROWSET function to access an SSAS 2008 database
446259	983286	FIX: "A connection cannot be made" error message in SSAS 2008 when you try to connect to a database

Oct 7, 2011 - Microsoft released Service Pack 3 (SP3) for SQL Server 2008

webadmin@ssas-info.com (SSAS-Info.com) — Fri, 07 Oct 2011 19:56:43 +0000

Oct 7, 2011 - Microsoft released Service Pack 3 (SP3) for SQL Server 2008

Microsoft SQL Server 2008 Service Pack 3 (SP3) is now available for download. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. A few key enhancements for customers in Microsoft SQL Server 2008 Service Pack 3 are :

Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP3. In addition, we have increased the performance & reliability of the setup experience.
In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor).
Superior user experience with Sequence Functions (e.g Row_Numbers()) in a Parallel execution plan.

Microsoft SQL Server 2008 Service Pack 2 is not a prerequisite for installing SQL Server 2008 Service Pack3. These packages may be used to upgrade any of the following editions of SQL Server 2008:

Enterprise
Standard
Evaluation
Developer
Workgroup

SQL Server 2008 SP3 contains the cumulative updates of SQL Server 2008 SP2 cumulative update package 1 to 4, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported through Windows Error Reporting.

List of bugs that are fixed in SQL Server 2008 SP3...

Download SQL Server 2008 SP3 here...

Sep 20, 2011 - Microsoft released Cumulative Update package 6 (CU6) for SQL Server 2008 Service Pack 2 (SP2)

webadmin@ssas-info.com (webadmin) — Tue, 20 Sep 2011 23:31:32 +0000

On Sep 20, 2011 - Microsoft released Cumulative Update package 6 (CU6) for SQL Server 2008 Service Pack 2 (SP2)

Cumulative update package 6 for Microsoft SQL Server 2008 Service Pack 2 (SP2) contains hotfixes for the SQL Server 2008 issues that were resolved after the release of SQL Server 2008 SP2.

Note This build of the cumulative update package is also known as build 10.00.4321.0.

List of fixes related to SQL Server Analysis Services 2008R2:

SQL Bug Number	KB Article Number	Description
790056	2605756	FIX: Internal Error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008 or SSAS 2008 R2
777277	2591295	FIX: SSAS 2008 or SSAS 2008 R2 crashes when you perform synchronization in TFS 2010 after you rebuild a cube

Aug 17, 2011 - New book released "MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook"

webadmin@ssas-info.com (SSAS-Info.com) — Wed, 17 Aug 2011 23:55:07 +0000

August 17, 2011 - New book released "MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook" by Tomislav Piasevoli.

Amazon US

Amazon UK

Amazon Canada

This cookbook contains over 70 practical, task-based recipes that show how Microsoft SQL Server 2008 R2 Analysis Services solutions can be taken further by enriching them with high-performance MDX calculations and flexible MDX queries.

Packed with immediately usable, real-world recipes, the book starts with elementary techniques that lay the foundation for designing further MDX calculations and queries. Here you will find topics such as iterations on a set, Boolean logic, and dissecting and optimizing MDX calculations.

In the first half of the book you will learn how to efficiently work with time, strings, metadata, calculated members and sets in general, and how to implement MDX solutions that are appropriate in a particular context: a time-aware calculation, a concise report, a calculation relative to another. You will also learn how to implement various types of conditional formatting, how to perform typical MDX calculations like ranks, percentages and averages, and year-to-date calculations.

The book then deep dives into topics such as enhancing cube design with utility dimensions, context-aware calculations, and other advanced topics. In this part you will learn how a utility dimension can be of great help, for example when you want to calculate histograms or implement time-based calculations. The advanced topics also cover parent-child hierchies, recursion, random values, and complex sorts.

Enrich your Business Intelligence solutions with over 70 recipes for high-performance MDX calculations and flexible MDX queries

Aug 17, 2010 - Microsoft released Cumulative Update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1

webadmin@ssas-info.com (SSAS-Info.com) — Wed, 17 Aug 2011 23:42:56 +0000

On Aug 17, 2010 - Microsoft released Cumulative Update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1

List of fixes related to SQL Server Analysis Services 2008R2:

SQL Bug Number	KB Article Number	Description
726744	2535660	FIX: Role membership is synchronized even if the SynchronizeSecurity element is set to the SkipMembership value in SSAS 2008 or in SSAS 2008 R2
748217	2567763	FIX: Aggregation design assignment might be removed in SSAS 2008 R2 if you run the Analysis Services Deployment Wizard to deploy a database

Please also check related release of "Cumulative update package 9 for SQL Server 2008 R2".

On July 18, 2011 Microsoft released cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1

webadmin@ssas-info.com (SSAS-Info.com) — Tue, 19 Jul 2011 02:07:48 +0000

On July 18, 2011 Microsoft released cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1.

List of fixes related to SQL Server Analysis Services 2008R2:

SQL Bug Number	KB Article Number	Description
746736	2547017	FIX: Instances of DAX functions that have no names incorrectly appear when you add a calculated member to a report that uses an SSAS 2008 R2 database as a data source
746729	2535660	FIX: Role membership is synchronized even if the SynchronizeSecurity element is set to the SkipMembership value in SSAS 2008 or in SSAS 2008 R2
718953	2531172	FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 R2 Analysis Services
718910	2521127	FIX: PowerPivot window does not open when you open an .xla or .xlam file in Excel 2010 if PowerPivot for Excel 2010 is installed
718946	2518876	FIX: MDX query incorrectly returns NULL or 0 values for some measures if a calculated member is used on the row axis in SSAS 2008 R2

Please also check related release of "Cumulative update package 15 for SQL Server 2008 Service Pack 1".