O'Reilly logo

Pro SQL Server 2008 Analysis Services by Philo Janus Guy Fouché

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14. User Interfaces

We've looked at a lot of things we can do with dimensional data, and we've picked apart how to build cubes and mine the data contained in them. However, most of our work has been in BIDS, which isn't exactly a user-friendly front end. So how do we get the value of our OLAP solutions out to "the general population"? In this chapter we'll look at the various front ends we can leverage to display the data in our cubes.

We'll start with Excel 2007, which we've used in a few exercises. I'll review connecting to an OLAP data source, and building pivot tables and pivot charts. Then I'll show how to use native Excel functions on OLAP data to create some presentable interactive reports. Also from the Office suite, I'll show how ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required