OBIEE 11G Create a Share Measure 2

10 . Using the toolbar, click the Division button. Another set of angle brackets appears, <>.
Screenshot for Step
11 . Click <>.
Screenshot for Step
12 . Insert Logical Tables > F1 Revenue > Product Total Revenue. Recall that this is the total measure for the hierarchy.
Screenshot for Step
13 . Click between the last set of angle brackets, <>, and enter 1. This represents the number of digits of precision with which to round the integer.
Screenshot for Step
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.
Screenshot for Step
16 . Click OK to close the Logical Column dialog box. The Product Share logical column is added to the business model.
Screenshot for Step
17 . Add the Product Share measure to the Base Facts presentation table.
Screenshot for Step
18 . Save the repository. Check consistency. You should receive the following message.
Screenshot for Step
If there are consistency errors or warnings, correct them before you proceed.
19 . Close the repository.

No comments:

Post a Comment

Popular Posts