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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.