The Business Model and Mapping layer is where physical schemas are simplified and reorganized to form the basis of the users’ view of the data. It contains the business model definitions and the mappings from logical to physical tables. The main purpose of the business model is to capture how users think about their business using their own vocabulary.
BMM Layer Objects
· There can be multiple business models in this layer.
· The business model object is the highest-level object, and it contains logical tables, logical table sources, logical columns, logical keys etc.
· Logical tables also have a Sources folder that contains one or more logical table sources. These logical table sources define the mappings between the logical table and the physical tables where the data is actually stored.
· In the Business Model and Mapping layer, data is separated and simplified into facts and dimensions.
· Business Model and Mapping layer objects map to source data objects in the Physical layer.
· Use the naming convention to re structure the model for easy understanding.