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.
Figure 5–3. The Define Relationship dialog box Advanced option allows you ...
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.
