• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Create Simple Measures in OBIEE

Create Simple Measures in OBIEE

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

73

2 . Click the Aggregation tab.

74

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

3 . Change the default aggregation rule to Sum.

75

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.

76

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

77

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 indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Create Simple Measures in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Create Simple Measures in OBIEE"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.