Skip to main content


Showing posts from February, 2012

Learn Reporting Services in a Day!

I am excited to be presenting a pre-conference session at the Atlanta SQLSaturday on April 13, 2012.  The session is entitled Learn Reporting Services in a Day! and is a full day introduction to SSRS 2008 R2.  It costs $99.00 through March 15, and $109.00 after that.  There are only 16 seats left, so don’t hesitate to sign up here: In addition, there is a full slate of sessions on April 14, 2012, including my session: Report Parts: Increasing Productivity Since 2008R2. Here is the information about the pre-conference session: SQL Server MVP, Jessica M. Moss, presents an exciting, introductory, full day training session on SQL Server Reporting Services 2008 R2. In the three-part class, Jessica will teach you how to build reports from the ground up. In Part 1, learn the basics of report development, including picking a report development tool and creating your first report. Part 2 delves into visualizations, groupings, and drill-down functi

Displaying Images from Analysis Services

One of the things we love in business intelligence is pretty pictures. We want to be able to show graphs and KPIs that really highlight information and direct people to an accurate conclusion. We also want to be able to show images that help tell a story, such as a picture of a certain location or the logo for a store. Analysis Services provides the functionality to show images, but it’s a little buried. Let’s walk through the steps of making it easier for you to access! Our final product will look like this: Setting up Analysis Services to show the image Let’s work with the AdventureWorks 2008 R2 sample database and Analysis Services cube. In the product dimension, there is already an attribute in the database and Analysis Services cube called LargePhoto with a data type of varbinary(max) . This contains an image that is associated with each product in the dimension. In fact, in the Analysis Services dimension, we can see that it has been set up so that the ValueCo