OBIEE 11G Create a Share Measure

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."
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, <>.
11 .	Click <>.
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, <>, 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. If there are consistency errors or warnings, correct them before you proceed.
19 .	Close the repository.