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

Apr 17, 2012 - Microsoft released Cumulative Update package 6 (CU6) for SQL Server 2008 R2 SP1

webadmin@ssas-info.com (SSAS-Info.com) — Wed, 18 Apr 2012 02:47:55 +0000

On Apr 17, 2012 - Microsoft released Cumulative Update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1 (SP1).

Cumulative update package 6 for Microsoft SQL Server 2008 R2 SP1 contains hotfixes for issues that were fixed after the release of SQL Server 2008 R2 SP1.

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

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

SQL Bug Number	KB Article Number	Description
834643	2638932	FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2
871718	2675233	FIX: Slow performance when you run an MDX query that uses some sub queries in SSAS 2008 R2
887487	2682819	FIX: SQL Server 2008 R2 may stop responding when you perform many Update Cube writeback transactions on multiple cubes that belong to different SSAS 2008 R2 databases

April 12, 2012 - Microsoft released CU1 for SQL Server 2012

webadmin@ssas-info.com (SSAS-Info.com) — Fri, 13 Apr 2012 02:30:29 +0000

April 12, 2012 - Microsoft released Cumulative Update 1 (CU1) for SQL Server 2012.

This update contains hotfixes for issues that were fixed after the release of SQL Server 2012.

Note: This build number of this cumulative update package is 11.0.2316.0.

List of fixes related to SQL Server Analysis Services 2012:

Bug number	KB Number	Description
899274	2562753	FIX: Slow performance when an MDX query uses unary operators on parent/child hierarchy members in SSAS 2008 R2 or in SSAS 2012 if you define a scope calculation on these members and if the query accesses multiple dates in a time dimension
887635	2574714	FIX: Incorrect results when an MDX query runs against an SSAS 2008 or an SSAS 2012 database if you set the RealTimeOlap property to True
892370	2588047	FIX: MDX query incorrectly returns a NULL value in SSAS 2008 R2 or in SSAS 2012 if a linked cube contains a many-to-many dimension and a distinct count measure group
892362	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 or in SSAS 2012
885533	2605756	FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008, to SSAS 2008 R2 or to SSAS 2012
899270	2606211	FIX: Error when a complex MDX query has the NONEMPTY clause in SSAS 2008 R2 or in SSAS 2012 if the WHERE clause has a named set
899281	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 or in SSAS 2012
892372	2629168	FIX: Internal error when you update a cellset that is returned after you run a query against a perspective in SSAS 2008 R2 or in SSAS 2012
885539	2636425	FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2 or in SQL Server 2012
881813	2638932	FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2
896199	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
885548	2661225	FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer
875390	2683293	FIX: "Deserialization failed: Requested value '<ServerEdition>' was not found" error message when you use AMO to connect to SQL Server 2012 Analysis Services
887665	2685308	FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence
893254	2693568	FIX: Out-of-memory error when you run a DAX query against a Tabular model in SQL Server 2012 Analysis Services

Mar 19, 2012 - Microsoft released Cumulative Update package 9 (CU9) for SQL Server 2008 Service Pack 2

webadmin@ssas-info.com (SSAS-Info.com) — Thu, 22 Mar 2012 01:40:10 +0000

On Mar 19, 2012 - Microsoft released Cumulative Update package 9 (CU9) for SQL Server 2008 Service Pack 2

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

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

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

SQL Bug Number	KB Article Number	Description
861760	2498839	FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2 or in SSAS 2008
880519	2673997	FIX: "The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008

Please also check related updates: Cumulative Update package 4 (CU4) for SQL Server 2008 Service Pack 3(SP3)

March 10, 2012 - Microsoft re-brands the Vertipaq engine that runs inside PowerPivot and Analysis Services to xVelocity in-memory analytics engine

webadmin@ssas-info.com (Microsoft) — Tue, 13 Mar 2012 01:42:41 +0000

March 10, 2012 - Microsoft re-brands the Vertipaq engine that runs inside PowerPivot and Analysis Services to xVelocity in-memory analytics engine.

Along with the SQL Server 2012 launch, Microsoft announced xVelocity in-memory technologies, delivering huge performance improvements for data warehousing and business intelligence. The purpose of this blog post is to clarify what xVelocity means for business intelligence and Analysis Services in particular.

In SQL Server 2008 R2, Microsoft released PowerPivot for Excel which introduced an in-memory analytics engine called VertiPaq. Vertipaq enables Excel to process hundreds of millions of rows with sub-second response times on desktop hardware. This engine uses in-memory column-oriented storage and innovative compression techniques to achieve these remarkable results.

March 6, 2012 - Microsoft announced SQL Server 2012 RTM

webadmin@ssas-info.com (SSAS-Info.com) — Tue, 06 Mar 2012 20:02:47 +0000

March 6, 2012 - Microsoft announced SQL Server 2012 RTM.

Customers and partners can download an evaluation of the product today and expect general availability to begin on April 1st.

For more information about this news check SQL Server 2012 Virtual Launch Event on March 7th, 2012.

Currently available download links:

Please also read:

Microsoft SQL Server 2012 Release notes

Feb 23, 2012 - New book released "Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling

webadmin@ssas-info.com (SSAS-Info.com) — Thu, 23 Feb 2012 18:24:35 +0000

Feb 23, 2012 - New book released "Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling by Teo Lachev".

Amazon US

Amazon UK

Amazon Canada

An insightful tour that provides an authoritative yet independent view of this exciting technology, this guide introduces the Tabular side of the innovative Business Intelligence Semantic Model (BISM) that promotes rapid professional and self-service BI. Business analysts and power users will learn how to integrate data from multiple data sources, implement personal BI applications with Excel, and deploy them to SharePoint. BI professionals and database administrators will discover how to build Tabular models that deliver supreme performance with large data volumes, and how to implement a wide range of solutions for the entire spectrum of personal-team-organizational BI needs. Ideal for experienced BI professionals and beginners, this book features step-by-step instructions and demos for integrating data from various data sources and gaining insights from the data in reports and dashboards.

Sample chapter: Introducing Business Intelligence Semantic Model

Link to video related to this book...

Feb 23, 2012 - Microsoft released Cumulative Update package 5 (CU5) for SQL Server 2008 R2 SP1

webadmin@ssas-info.com (SSAS-Info.com) — Thu, 23 Feb 2012 18:17:43 +0000

On Feb 23, 2012 - Microsoft released Cumulative Update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1 (SP1).

Cumulative update package 5 for Microsoft SQL Server 2008 R2 SP1 contains hotfixes for issues that were fixed after the release of SQL Server 2008 R2 SP1.

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

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

SQL Bug Number	KB Article Number	Description
799333	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 to SSAS 2008 R2
854092	2636425	FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2
853102	2653917	FIX: "The data refresh job failed because it has been inactive for more than 3600 seconds" error message when you use SQL Server 2008 R2 PowerPivot for SharePoint in some non-English environments
858625	2659075	FIX: Permissions across multiple roles are not additive as expected in SSAS 2008 R2
860062	2661225	FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer
856454	2675230	FIX: MDX query fails in SSAS 2008 R2 if the query contains a DAX expression that has many levels of nested binary operators

Feb 23, 2012 - Microsoft released Cumulative Update package 12 (CU12) for SQL Server 2008 R2

webadmin@ssas-info.com (SSAS-Info.com) — Thu, 23 Feb 2012 18:17:08 +0000

On Feb 23, 2012 - Microsoft released Cumulative Update package 12 (CU12) for SQL Server 2008 R2.

Cumulative update package 12 for Microsoft SQL Server 2008 R2 contains hotfixes for issues that were fixed after the release of SQL Server 2008 R2.

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

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

SQL Bug Number	KB Article Number	Description
834642	2638932	FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2

Feb 10, 2012 - Microsoft released BI Image X: SQL 2012 RC0

webadmin@ssas-info.com (SSAS-Info.com) — Sun, 12 Feb 2012 03:22:21 +0000

Feb 10, 2012 - Microsoft released BI Image X: SQL 2012 RC0

The Base ImageX Server is a virtual machine that allows a user to test out the latest Business Intelligence features of SQL Server 2012 – RC0; including PowerView reports and PowerPivot Excel Documents.

The Base ImageX Server is a virtual machine that can be hosted in Hyper-V that allows a user to test out the latest Business Intelligence features of SQL Server 2012 – RC0. The virtual machine has been configured to support the use of PowerView reports, PowerPivot Excel documents and various content packs allowing the user to explore the capabilities of SQL Server 2012. Working with the demos that can be installed on the ImageX server the user will have a clear picture of how the SQL Server 2012, Office and SharePoint tools support and enhance the self-service business intelligence environment.

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