Creating 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.

2

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.

2

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

2

Create a Calculation Measure Derived from Existing Columns

1 . In the BMM layer, expand Sample Sales > F1 Revenue.

2

2 . Right-click F1 Revenue and select New Object > Logical Column to open the Logical Column dialog box.

2

3 . On the General tab, enter Actual Unit Price in the Name field.

2

4 . Click the Column Source tab.

2

5 . Select Derived from existing columns using an expression.

2

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

2

7 . In the left pane select Logical Tables > F1 Revenue > Revenue.

2

8 . Click the Insert selected item button to move the Revenue column to the right pane.

2

At TekSlate, we offer resources that help you in learning various IT courses. 

We avail both written material and demo video tutorials.

To gain in-depth knowledge and be on par with  practical experience, then exploer OBIEE Training.

9 . Click the division operator to add it to the expression.

2

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

2

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

2

12 . Click OK to close the Logical Column dialog box. The Actual Unit Price calculated measure is added to the business model.

2

13 . Drag Actual Unit Price from the BMM layer to the Base Facts presentation table in the Presentation layer.

2

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

For in-depth understanding of OBIEE click on