Refining Your Cube

You can do many, many tasks to refine a cube that you've built using the BIDS wizard. In this chapter, we'll look at some simple and common cube refinements, including enhancing measures, dimensions, and the cube itself.

You'll learn the BIDS development interface as you proceed with these refinements. Although the environment is a GUI, it is complex; often, half the battle when working with BIDS is getting to the correct location in the development interface!

Reviewing Measures

A common and simple task when refining your cube is changing the display format of the measures. To do this, you just double-click the cube name (under the cubes folder in Solution Explorer) to open that cube in the BIDS cube design interface. This ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.