15/12/2009 9:37:09 PM
Reporting Services is great, but tends to prefer relational datasets. Analysis Services is great, but is multi-dimensional and uses MDX. But yet, the two technologies are remarkably complimentary if understood well enough.
In this talk, Rob Farley will look at using Reporting Services with an Analysis Services back end, but without a Report Model. We'll look at creating reports, and then taking them to the next level by examining the MDX, considering parameters (and customising them), drill-through mechanisms, and even how dynamic MDX can provide some uses. This talk will use both 2005 and 2008, showing some of the differences in the way that things are handled.
Rob Farley owns and operates LobsterPot Solutions out of Adelaide. He has been consulting and training across the SQL Server stack for over ten years, runs the Adelaide SQL Server User Group, and is a regular conference presenter. In addition, he has written both courseware and exam material for Microsoft Learning and Prometric, in the areas of .Net programming and SQL Server. He blogs at http://msmvps.com/blogs/robfarley, and his company URL is http://www.lobsterpot.com.au
Also, at this event a copy of the book SQL Server MVP Deep Dives will be auctioned, being given to the person who pledges the most money to the charity WarChild, which is the charity for whom the book was written.
Venue: L2 Westpac House (91 King William St, cnr Currie St) |
Duration 12:00-14:00 |
On: Monday, 21 December 2009