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:
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
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. |
---|---|
2. | Enter Sample Sales in the Name field. Leave Disabled checked. |
3. |
Click OK. The Sample Sales business model is added to the Business Model and Mapping layer. |
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. |
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. |
No comments:
Post a Comment