mobileNavlogo
headerlogo

Creating Calculation Measures in OBIEE

12 October, 2020

Ratings

Related Blogs

 

 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 the 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

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

For an in-depth understanding of OBIEE click on

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .