9 Working with Logical Tables, Joins, and Columns

This chapter explains how to work with objects in the Business Model and Mapping layer of the Oracle BI repository, such as logical tables, joins, and columns. It also explains other Business Model and Mapping layer concepts like display folders, bridge tables, the Business Model Diagram, and how to enable write back on columns.

This chapter contains the following sections:

• About Working with the Business Model and Mapping Layer

• Creating the Business Model and Mapping Layer

• About Working with the Business Model Diagram

• Creating and Managing Logical Tables

• Defining Logical Joins

• Creating and Managing Logical Columns

• Enabling Write Back On Columns

• Setting Up Display Folders in the Business Model and Mapping Layer

• Modeling Bridge Tables

• Modeling Binary Large Object (BLOB) Data and Character Large Object (CLOB) Data