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

2 . On the General tab, enter Revenue Rank in the Name field.

2

3 . Click the Column Source tab.

2

4 . Select Derived from existing columns using an expression.

2

5 . Click the Edit Expression button to open Expression Builder.

2

6 . In the left pane select Functions > Display functions > Rank .

2

7 . Click the Insert selected item button to move the Rank function to the right pane.

2

Desired to gain proficiency on OBIEE 11g? Explore the blog post on OBIEE 11g training online to become a pro in OBIEE 11g 

8 . Click <<numExpr>> in the expression.

2

9 . In the left pane select Logical Tables > F1 Revenue and then double-click Revenue to add it to the expression.

2

10 . Click OK to close Expression Builder. Notice that the formula is added to the Logical Column dialog box.

2

11 . Click OK to close the Logical Column dialog box. The Revenue Rank calculated measure is added to the business model.

2

12 . Drag Revenue Rank from the BMM layer to the Base Facts presentation table in the

Presentation layer.

2

13 . Save the repository and check consistency. Fix any errors or warnings before proceeding.

1

14 . Close the repository. Leave the Admin Tool open.

For indepth understanding of OBIEE click on