With the release of SQL Server 2012 (http://www.microsoft.com/sqlserver/en/us/default.aspx) and BIDS Helper 1.6 (http://bidshelper.codeplex.com/releases/view/68109), we can now finally develop for Analysis Services in Visual Studio 2010. Even better from a single project we can deploy to SQL 2005, SQL 2008R2 and SQL 2012. This means that the upgrade from 2008 to 2012 does not even have to involve … Continue reading Switching to Visual Studio 2010 for Analysis Services
Tag: SSAS
If you don’t give some love and attention to how you design your analysis cube and look at optimising processing then this is often fine at the very small cube size (under 2GB), but as you approach 10GB+ the first warning sign is usually horrendously long wait times for processing. The analysis Services Performance Guide … Continue reading The basics of faster fact processing in Analysis Services