# Create a Share Measure in OBIEE

Blog Author

Tekslate

Published Date

10th October, 2020

Ratings

Views

0

1 . In the Business Model and Mapping layer, right-click the F1 Revenue table and select New Object --> Logical Column to open the Logical Column dialog box.

2 . On the General tab, name the logical column Product Share.

3 . On the Column Source tab, select "Derived from existing columns using an expression."

Desired to gain proficiency on OBIEE Training? Explore the blog post on OBIEE  training to become a pro in "OBIEE Training"

4 . Open the Expression Builder.

5 . In the Expression Builder, Select Functions > Mathematic Functions > Round.

6 . Click Insert selected item. The function appears in the edit box.

7 . Click Source Number in the formula.

8 . Enter 100* followed by a space.

9 . Insert Logical Tables > F1 Revenue > Revenue.

10 . Using the toolbar, click the Division button. Another set of angle brackets appears, <<expr>>.

```Desired to gain proficiency on OBIEE Training?
Explore the blog post on OBIEE  training to become a pro in OBIEE Training Online.```

11 . Click <<expr>>.

12 . Insert Logical Tables > F1 Revenue > Product Total Revenue. Recall that this is the total measure for the hierarchy.

13 . Click between the last set of angle brackets, <<Digits>>, and enter 1. This represents the number of digits of precision with which to round the integer.

14 . Check your work: Round(100* "Sample Sales"."F1 Revenue"."Revenue" / "Sample Sales"."F1 Revenue"."Product Total Revenue" , 1) This share measure will allow you to run an analysis that shows how revenue of a specific product compares to total revenue for all products. 15 . Click OK to close the Expression Builder. The formula is visible in the Logical Column dialog box.

16 . Click OK to close the Logical Column dialog box. The Product Share logical column is added to the business model.

17 . Add the Product Share measure to the Base Facts presentation table.

18 . Save the repository. Check consistency. You should receive the following message.

19 . Close the repository.