Select Columns for Parent-Child Dimension (Dimension Wizard)

Analysis Services

Analysis Services

Select Columns for Parent-Child Dimension (Dimension Wizard)

In this step of the wizard, you select the two columns upon which the parent-child dimension is based. You can also select a column to provide member names.

This wizard step is displayed only if, in the second step of the wizard, you selected Parent-Child: Two related columns in a single dimension table.

Options

Member key

Select the column that uniquely identifies each member. The column must have the same data type as the column you select in the Parent key box.

Parent key

Select the column that uniquely identifies the parent of each member. This column defines the lineage relationships among the members. For each member, it determines the parent member. The column must have the same data type as the column you select in the Member key box.

Member name

Select the column that provides member names to be displayed to end users as they browse cubes.

See Also

Parent-Child Dimensions