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

Nulls

The OLAP community harbors differing opinions about whether or not it is appropriate to load null data into the fact (or dimension) tables of a cube. One of the places you can configure null value handling (for measure groups that intersect with regular [or star] dimensions only) is in the Dimension Usage tab of the cube designer in BIDS (refer to Figure 5–2). To do so, click the Build button on the white rectangle at the intersection of the dimension and fact table that you want to customize. This opens the Define Relationship dialog box, shown in Figure 5–3.

Image

Figure 5–3. The Define Relationship dialog box Advanced option allows you ...

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