OBIEE 11G Create a Calculation Measure Derived from Existing Columns

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