Using Report Builder against SQL Server 2005 Analysis Services – some things to watch out for


Last week I was presenting at Devweek on Analysis Services. As part of that I created a cube which I reported against using:


- The browser in AS
- A report generated in Report Designer
- An Excel sheet using PivotTables
- A web page saved from Excel using Office Web Components
- and finally, a report built in Report Builder.


Using Report Builder against a cube in Analysis Services proved "interesting" while I was preparing and I did get some funnies including reports that took a very long time to run. Turns out there is a nice KB on some of the things I came up against: http://support.microsoft.com/default.aspx?scid=kb;en-us;899825 

Comments (0)

Skip to main content