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.
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 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.
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 exploerOBIEE Training.
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 consistency. Fix any errors or warnings before proceeding.
For in-depth understanding of OBIEE click on