Create Parent-Child Dimension with SSAS

This post is about parent-child dimension in ssas.

In order to create parent-child dimension successfully, the parent's key and child's key must be save data type and the parent key should be relative to the primary key.

The step for creating the parent-child dimension describes as follows:

Step 1: define the relation in data source views.

Step 2: create dimension.

The parent-child relation will be created automatically when finished the first step 1.

Step 3: configure some relative properties.

1) modify the dimension property, right key in the dimension and modify the propertyUnknownMember to Hidden.

2) modify the dimension key, right key in the key and modify the property AttributeHierachyVisible to False.

3) modify the dimension parent key, right key in the parent key and modify the propertyMembersWithData to NonLeafDataHidden.

4) modify the dimension parent key, right key int he parent key and modity the propertyUsage to Parent.