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 ...

Get Pro SQL Server 2008 Analysis Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.