Define Members

To define members:

1.   Click Next.

The Define Members dialog box appears.

2.   Select field(s) from the Fields list box, on the left, and double-click or use the Add member button, so it appears in the Members list box (e.g., ProductName).

Now, each unique record in the listed field will be a Member in the Dimension you are creating.

Important


If you select more than one Field for inclusion in the Members list box for non-Measures dimensions (2nd, 3rd, etc. Dimensions), the resulting Members names will form a concatenation of the field records in each row of the table, separated by a space. For example, if ProductName and ProductID (which logically would be a number) were selected, you might see resulting Member names like 55 chili or 73 pasta, etc.

Note that now most check boxes are active at the bottom right. Again, the use of these check boxes will be discussed under the Modify Relational Dimension section of this manual. if you are consulting this manual to proceed in a real production environment, you will want to use these check boxes now.

To continue creation of 2nd Dimension (Products), see succeeding topics:

• Define Aliases
• Define Properties
• Define Hierarchy