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.
Screenshot for Step
3 . On the Column Source tab, select "Derived from existing columns using an expression."
Screenshot for Step
4 . Open the Expression Builder.
Screenshot for Step
5 . In the Expression Builder, Select Functions > Mathematic Functions > Round.
Screenshot for Step
6 . Click Insert selected item. The function appears in the edit box.
Screenshot for Step
7 . Click Source Number in the formula.
Screenshot for Step
8 . Enter 100* followed by a space.
Screenshot for Step
9 . Insert Logical Tables > F1 Revenue > Revenue.
Screenshot for Step




















No comments:

Post a Comment

Popular Posts