OBIEE 11G Create a Calculation Measure Using a Function

1 .	In the BMM layer, right-click F1 Revenue and select New Object > Logical Column to open the Logical Column dialog box.
2 .	On the General tab, enter Revenue Rank in the Name field.
3 .	Click the Column Source tab.
4 .	Select Derived from existing columns using an expression.
5 .	Click the Edit Expression button to open Expression Builder.
6 .	In the left pane select Functions > Display functions > Rank .
7 .	Click the Insert selected item button to move the Rank function to the right pane.
8 .	Click <> in the expression.
9 .	In the left pane select Logical Tables > F1 Revenue and then double-click Revenue to add it to the expression.
10 .	Click OK to close Expression Builder. Notice that the formula is added to the Logical Column dialog box.
11 .	Click OK to close the Logical Column dialog box. The Revenue Rank calculated measure is added to the business model.
12 .	Drag Revenue Rank from the BMM layer to the Base Facts presentation table in the Presentation layer.
13 .	Save the repository and check consistency. Fix any errors or warnings before proceeding.
14 .	Close the repository. Leave the Admin Tool open.