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.
Screenshot for Step
2 . In the Logical Dimension dialog box, on the General tab, name the logical dimension H5 Sales Rep.
Screenshot for Step
3 . Click Browse next to Member Key. The Browse window shows the physical table and its corresponding key.
Screenshot for Step
4 . Click View to open the Logical Key dialog box. Confirm that the Sales Rep Number column is selected
Screenshot for Step
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.
Screenshot for Step
8 . Deselect Show Qualified Names and select Manager Number as the parent column for the parent-child hierarchy.
Screenshot for Step
9 . Click OK to close the Browse window, but do not close the Logical Dimension dialog box.

No comments:

Post a Comment

Popular Posts