OBIEE 11G 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


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.
Screenshot for Step
 
2. Enter Sample Sales in the Name field. Leave Disabled checked.
Screenshot for Step

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

No comments:

Post a Comment

Popular Posts