Reporting Services Staaaarrrrrtttt Up

I hear the complaint a lot that after a time period of no calls to Reporting Services, the first call to the Reporting Services instance is very slow.  This is totally expected because the application pool generally gets spun down and we need to restart everything. If you wire up some basic web service calls,…


Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases…

An Analysis Services 2005 query against a calculation on a cell may report the error:  “The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples.”  This may be because there are simply more underlying cells in the query than the supported maximum, but in some cases, the query can…