There we had selected the NONE member of
Entity dimension as the default value for the Entity member property of Employee
dimension. Once the Employee and Entity dimensions are loaded with members, the
appropriate relationship between the dimensions can be defined for each member of
the referencing Employee dimension.
For each member (row) in the referencing dimension, the corresponding value
for the referenced dimension can be selected by clicking on ellipsis (??¦) button that
is available to the right of the current value of the dimension property that serves as
the link between the referencing and referenced dimensions, and then selecting the
appropriate referenced dimension member from the Select Members dialog box. In the
example given in this chapter, clicking the ellipsis (??¦) button next to the NONE value
in the Entity column for any member in the Employee dimension (as shown in the top
half of Figure 7-22) will open the Member Selector. This in turn displays the available
members in the referenced Entity dimension. Select the check box next to the Name of
the appropriate Entity dimension member and then click OK to establish the referential
relationship. The bottom half of Figure 7-22 shows the Entity dimension property
values for all Employee dimension members. The referential relationship can be
defined for dimension members during the data loading process as well. But a detailed
explanation of those techniques is beyond the scope of this chapter.
Pages:
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329