13th October, 2020
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.
If you want to enrich your career and become a professional in OBIEE, then visit Tekslate - a global online training platform: "OBIEE Training" This course will help you to achieve excellence in this domain.
To build the Business Model and Mapping layer of a repository, you perform the following
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
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.
For an in-depth understanding of OBIEE click on:
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us