Creating Calculation Measures in OBIEE

Calculation Measures in OBIEE

In this set of steps, you use existing measures to create a derived calculation measure. To create a derived calculation measure you perform the following steps: • Open the Repository in Offline Mode • Create a Calculation Measure Derived from Existing Columns

. Create a Calculation Measure Using a Function • Load the Repository • Create and Run an Analysis • Check the Query Log

Open the Repository in Offline Mode

1 . Return to the Administration Tool, which should still be open. If not, select Start --> Programs --> Oracle Business Intelligence --> BI Administration. 2 . Select File --> Open --> Offline.

3 . Select BISAMPLE.rpd and click Open. Do not select any BISAMPLE repository with an extension, for example, BISAMPLE_BI0025.rpd. Recall that these are the repositories that have been loaded into Oracle BI Server memory.

4 . Enter BISAMPLE1 as the repository password and click OK to open the repository.

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 the 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 the consistency. Fix any errors or warnings before proceeding.