1. Building Semantic Models in Oracle Analytics Server
  2. Create and Build Your Model
  3. Build a Semantic Model's Logical Layer
  4. Create a Business Model in the Logical Layer

Create a Business Model in the Logical Layer

A business model contains logical tables, logical columns, logical table sources, and logical hierarchies. The business model also contains mappings from logical to physical tables.

A business model can map to more than one data source. Data mapping can also come from different granularity within data sources.

The logical layer can contain one or more business models.

To add tables to the business model, you can drag tables from the physical layer to the business model. Or you can create new fact, dimension, and lookup tables within the business model.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Logical Layer.
  4. In the Logical Layer pane click Create and then click Create Business Model.
  5. In Create Business Model, go to the Name field and type a name. Click OK.
    The new business model's tab is displayed and opens to Logical Tables.