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

No comments:

Post a Comment

Popular Posts