OBIEE 11G Create Simple Measures

1 . Double-click the Revenue logical column to open the Logical Column dialog box.
Screenshot for Step
2 . Click the Aggregation tab.
Screenshot for Step

3 . Change the default aggregation rule to Sum.
Screenshot for Step

4 . Click OK to close the Logical Column dialog box. Notice that the icon has changed for the Revenue logical column indicating that an aggregation rule has been applied.
Screenshot for Step

5 . Repeat the steps to define the SUM aggregation rule for the Units logical column.
Screenshot for Step
Measures are typically data that is additive, such as total dollars or total quantities. The F1 Revenue logical fact table contains the measures in your business model. You aggregated two logical columns by summing the column data.

6 . Save the repository without checking global consistency.
Congratulations! You have successfully built a business model in the Business Model and Mapping layer of a repository and created business measures.

No comments:

Post a Comment

Popular Posts