Create Simple Measures in OBIEE

1 . Double-click the Revenue logical column to open the Logical Column dialog box.


2 . Click the Aggregation tab.

At TekSlate, we offer resources that help you in learning various IT courses. We avail of both written material and demo video tutorials. To gain in-depth knowledge and be on par with practical experience, then explore "OBIEE Training."

3 . Change the default aggregation rule to Sum.


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.


5 . Repeat the steps to define the SUM aggregation rule for the Units logical column.


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.

For an in-depth understanding of OBIEE click on: