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.
For an in-depth understanding of OBIEE click on
- OBIEE 11g Tutorials
- New Features in OBIEE11g
- Checking Out a Project in OBIEE 11g
- Making Changes to the Repository in OBIEE
- Setting Up a Multiuser Development Environment in OBIEE