OBIEE 11G Create a Share Measure 1

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.