O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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

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