Once a dimension is checked out,
it will appear similar to the newly created Employee dimension shown in Figure
7-16. Please note that in this example we have not yet saved or checked in our
newly created Employee dimension from our previous example. We will be using
this example to create the new user-defined dimension member property. If the
dimension has been checked in, it has to be checked out as was just described.
From the Dimension Tasks pane on the right side, click the link Create a Member
Property. This will open the Create Member Property dialog box, as shown in
Figure 7-17. The various aspects of the dimension member property are defined
in this dialog box. The value Entity is entered in the text boxes titled Label and
Description for the purpose of the examples in this chapter. The next step is to
select the type of data that the dimension member property will contain. The
various available data types are listed in the drop-down list titled Data Types. Most
of the data types listed here are self explanatory, with the exception of Member of
Dimension data type. This data type allows you to create referential relationships
among dimensions, by allowing you to select a member belonging to another
referenced dimension as the member property for the referencing dimension. For
the purpose of the examples in this chapter, the Member of Dimension data type is
Figure 7-17 The Member of Dimension data type allows you to create referential
relationships among dimensions.
Pages:
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321