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

Building the Business Model and Mapping Layer of a Repository

In this topic you use the Oracle BI Administration Tool to build the Business Model and Mapping layer of a repository.

The Business Model and Mapping layer of the Administration Tool defines the business, or logical, model of the data and specifies the mappings between the business model and the Physical layer schemas. This layer is where the physical schemas are simplified to form the basis for the users’ view of the data. The Business Model and Mapping layer of the Administration Tool can contain one or more business model objects. A business model object contains the business model definitions and the mappings from logical to physical tables for the business model.

The main purpose of the business model is to capture how users think about their business using their own vocabulary. The business model simplifies the physical schema and maps the users’ business vocabulary to physical sources. Most of the vocabulary translates into logical columns in the business model. Collections of logical columns form logical tables. Each logical column (and hence each logical table) can have one or more physical objects as sources.

There are two main categories of logical tables: fact and dimension. Logical fact tables contain the measures by which an organization gauges its business operations and performance. Logical dimension tables contain the data used to qualify the facts.

To build the Business Model and Mapping layer of a repository, you perform the following

steps:

  • Create a Business Model
  • Examine Logical Joins
  • Examine Logical Columns
  • Examine Logical Table Sources
  • Rename Logical Objects Manually
  • Rename Logical Objects Using the Rename Wizard
  • Delete Unnecessary Logical Objects
  • Create Simple Measures

Create a Business Model

Examine Logical Joins

Examine Logical Columns

Examine Logical Table Sources

Rename Logical Objects Manually

Rename Objects Using the Rename Wizard

Delete Unnecessary Logical Objects

Create Simple Measures

Create a Business Model

1. Right-click the white space in the Business Model and Mapping layer and select New Business Model to open the Business Model dialog box.

40

2. Enter Sample Sales in the Name field. Leave Disabled checked.

41

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. Click OK. The Sample Sales business model is added to the Business Model and Mapping layer.

42

4. In the Physical layer, select the following four alias tables:
D1 Time
D2 Product
D3 Customer
F1 Revenue
Do not select D4 Address at this time.

43

5 . Drag the four alias table from the Physical layer to the Sample Sales business model in the Business Model and Mapping layer. The tables are added to the Sample Sales business model. Notice that the three dimension tables have the same icon, whereas the F1 Revenue table has an icon with a # sign, indicating it is a fact table.

43

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Building the Business Model and Mapping Layer of a Repository 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 Building the Business Model and Mapping Layer of a Repository in OBIEE"

    Leave a Message

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

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.