OBIEE 11G Create a Parent-Child Logical Dimension

1 .	Right-click the D5 Sales Rep logical table and select Create Logical Dimension > Dimension with Parent-Child Hierarchy.
2 .	In the Logical Dimension dialog box, on the General tab, name the logical dimension H5 Sales Rep.
3 .	Click Browse next to Member Key. The Browse window shows the physical table and its corresponding key.
4 .	Click View to open the Logical Key dialog box. Confirm that the Sales Rep Number column is selected
5 .	Click Cancel to close the Logical Key dialog box.
6 .	Click OK to close the Browse window.
7 .	Click Browse next to Parent Column. The Browse window shows the columns other than the member key.
8 .	Deselect Show Qualified Names and select Manager Number as the parent column for the parent-child hierarchy.
9 .	Click OK to close the Browse window, but do not close the Logical Dimension dialog box.