Follow

How to build a Parent-Child dimension

Introduction

A parent-child dimension is based on two dimension table columns that together define the lineage 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.

Example

This is an example of a employee table that is well suited for a parent-child example:

2012-06-15_09h03_33.png

 

To build a parent-child dimension, select Add Parent Child Dimension on the Dimension node on the Cubes tab:

2012-06-15_09h05_31.png

 

Setup the parent child dimension properties:

2012-06-15_09h34_52.png

  1. Name of the parent child dimension
  2. The Data Warehouse table that contains the data
  3. The Member key column
  4. The Parent key column
  5. The appearance.

The dimension will be created with two "levels". The Member Key level and the Parent Key level.

Since the Parent Key level contains the actual parent-child structure, it is recommended to rename this to the same name as the parent child dimension:

2012-06-15_09h40_34.png

 

Deploy and execute, and you have a parent-child dimension.


This article applies to: tX2012, TX2014. Last updated: 2014-04-01.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.