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, <<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
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.
“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at firstname.lastname@example.org, we will update the article in 24 hours.”