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.
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
