OBIEE 11G Set Logical Level Keys

1 .	Double-click the Product Brand logical level to open the Logical Level dialog box. On the General tab, notice that the Product LOB child level is displayed.
2 .	Click the Keys tab.
3 .	Enter Brand for Key Name.
4 .	In the Columns field, use the drop down list to select D2 Product.Brand.
5 .	Check Use for Display. When this is selected, users can drill down to this column from a higher level.
6 .	Set Brand as the Primary key.
7 .	Click OK to close the Logical Level dialog box. The icon changes for Brand to show that it is the key for the Product Brand level.
8 .	Use a different technique to create a logical level key: Right-click Lob for the Product LOB level and select New Logical Level Key to open the Logical Level Key dialog box.
9 .	In the Logical Level Key dialog box, accept the defaults and click OK.
10 .	The icon changes for Lob to show that it is the key for the Product LOB level.
11 .	Use either method to set the remaining keys for the H2 Product logical dimension: Logical Level Logical Level Key Use for Display Product Type Type Yes Product Detail Product Yes Product Detail Prod Key No Your results should look similar to the screenshot: Please note that the Detail level (lowest level of the hierarchy) must have the column that is the logical key of the dimension table associated with it and it must be the key for that level: Prod Key in this example.
12 .	Set Prod Key as the primary key for the Product Detail level. Hint: Double-click the level and select the Keys tab.