OBIEE 11G Create Level-Based Measures

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.
Screenshot for Step
2 . On the General tab, enter Product Total Revenue in the Name field.
Screenshot for Step
3 . Click the Column Source tab.
Screenshot for Step
4 . Select Derived from existing columns using an expression.
Screenshot for Step
5 . Open the Expression Builder.
Screenshot for Step
6 . In the Expression Builder, add Logical Tables > F1 Revenue > Revenue to the expression. Recall that the Revenue column already has a default aggregation rule of Sum.
Screenshot for Step
7 . Click OK to close Expression Builder.
8 . Click the Levels tab.
Screenshot for Step
9 . For the H2 Product logical dimension, select Product Total from the Logical Level drop-down list to specify that this measure should be calculated at the grand total level in the product hierarchy.
Screenshot for Step
10 . Click OK to close the Logical Column dialog box. The Product Total Revenue measure appears in the Product Total level of the H2 Product logical dimension and the F1 Revenue logical fact table.
Screenshot for Step
11 . Repeat the steps to create a second level-based measure:
Name
Logical Dimension
Logical Level
Product Type Revenue H2 Product Product Type
Screenshot for Step
12 . Expose the new columns to users by dragging Product Total Revenue and Product Type Revenue to the Base Facts presentation table in the Sample Sales subject area in the Presentation layer. You can drag the columns from either the H2 Product logical dimension or the F1 Revenue logical table.
Screenshot for Step

No comments:

Post a Comment

Popular Posts