back

Parent-child dimensions

A parent-child dimension is based on two table columns that together define the relationships among the members of the dimension. One column, called the member key column, identifies each member; the other column, called the parent key column, identifies the parent of each member. This information is used to create parent-child links.



For example, in the Employees table, the column that identifies each member is EmployeeID. The column that identifies the parent of each member is ReportsTo. (This column stores the EmployeeID of each employee's manager.)

Step 1
Click the "Lastname" column in the preview window

Step 2
Create a new dimension based on this column

Step 3
The new dimension is displayed in the left view

Step 4
Now, right-click the dimension item, and select Properties

Step 5
Change the dimension name and check "This is a PARENT-CHILD dimension"

Step 6
Now, right-click the level item, and select Properties

Step 7
Change the Level name if required.

Click the Arrow button to change the Name value if required (see how to concatenate columns).

Step 8
Now, you need to add two properties to the dimension level.

Click the Add button and select KEY.

Step 9
Use the Arrow button to select the right table column.

Step 10
Click the Add button again and select PARENT.

Use the Arrow button to select the right table column.

Important
It is NOT possible to add more custom properties to parent-child dimensions.

Congratulations!
Rebuild your cube to see the results!

Important:
A parent-child dimension can only have ONE level.


back