• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Create a Share Measure in OBIEE

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.

2

3 . On the Column Source tab, select “Derived from existing columns using an expression.”

2

4 . Open the Expression Builder.

2

5 . In the Expression Builder, Select Functions > Mathematic Functions > Round.

2

6 . Click Insert selected item. The function appears in the edit box.

2

7 . Click Source Number in the formula.

2

8 . Enter 100* followed by a space.

2

9 . Insert Logical Tables > F1 Revenue > Revenue.

2

10 . Using the toolbar, click the Division button. Another set of angle brackets appears, <<expr>>.

2

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>>.

2

12 . Insert Logical Tables > F1 Revenue > Product Total Revenue. Recall that this is the total measure for the hierarchy.

2

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.

2

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.

2

16 . Click OK to close the Logical Column dialog box. The Product Share logical column is added to the business model.

2

17 . Add the Product Share measure to the Base Facts presentation table.

2

18 . Save the repository. Check consistency. You should receive the following message.

2

19 . Close the repository.

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Create a Share Measure in OBIEE
Author Rating
5

“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 info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Create a Share Measure in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.