OBIEE 11G Create a Calculation Measure Derived from Existing Columns

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

No comments:

Post a Comment

Popular Posts