Timeout Error from Excel Services – “Unable to refresh data for a data connection in the workbook”

Applies to: SharePoint 2010 Excel Services, SQL Server 2005, 2008, 2008 R2, 2012 Analysis Services If you ever get the following error while using Excel Services to kick off a document to query the data from an Analysis Services database, you may wonder where the error come from and how to control it. “Unable to…


SQL Server Analysis Services Multidimensional Model – Merging Partitions with Slice

According to SQL Server Books Online: Partitions can be merged only if you meet all of the following criteria: http://technet.microsoft.com/en-us/library/ms175318.aspx. They are in the same cube. ·        They have the same structure. ·        They have the same storage modes. ·        They contain identical aggregation designs. ·        They share the same string store compatibility level (applies…


Side effects of storing an Analysis Services partition data in a non-default location

In 2005 and 2008, SQL Server Analysis Services allows users to store partition data in a non-default location. That is something we could not do in 2000 version. To store a partition data in a non-default location means that you can have the partition storage location set to some folder other than the default data…


Sum of a SQL Analysis Services calculated measure within a Reporting Services report gives #Error

Summing a SQL Analysis Services calculated measure result within a Reporting Services report gives #Error but the same calculated measure output can be summed within Analysis Services perfectly fine. Environment: SQL Server 2008 Analysis Services and Reporting Services + SP1, Report builder 2.0 sp1. This should be applicable to all SQL 2008 and 2005  Reporting…


Possible performance implications when using string parameters in Reporting Services

In Reporting Services String Parameters are of type Unicode. This could have unwanted side effects if comparing with a varchar ( or non-unicode data type) on the data source due to conversions that could occur from the non-Unicode column to the Unicode column as the resulting query plans may use scan’s instead of seeks. This…


Chart behavior difference in SQL Reporting Services 2008

There are some changes in behavior in Reporting Services Charts with regards to “Empty Points” between SQL 2005 and SQL 2008  (http://msdn.microsoft.com/en-us/library/dd207051.aspx) Let us consider the following Dataset: create table #TestChart (   Runtime datetime,   SensorReading int,   SensorName varchar(20) ) insert into #TestChart values(‘2009-01-30 1:30:00′,165,’SENSOR_A’) insert into #TestChart values(‘2009-01-30 1:31:00′,145,’SENSOR_B’) insert into #TestChart…