[OBIEE 11g] Create Simple Measures

 

OBIEE 11G Create Simple Measures

1 .	Double-click the Revenue logical column to open the Logical Column dialog box.
2 .	Click the Aggregation tab.
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.