Guidelines for Identifying the Logical Layer's Content

Use this sequence to determine what content to include in your semantic model's logical layer.

1. Identify the logical columns that users need to query.
2. Identify each column's role as either a measure column or a dimensional attribute.
3. Arrange the logical columns in a dimensional model based on the relevant roles, relationships between columns, and logic.

Businesses are analyzed by relevant dimensional criteria, and the business model is developed from these relevant dimensions. These dimensional models form the basis of the valid business models to use with the Oracle Analytics query engine.

Although not all dimensional models are built around a star schema, it's a best practice to use a simple star schema in the business model layer. In other words, the dimensional model should represent some measurable facts that are viewed in terms of various dimensional attributes.

After you analyze your business model requirements, you need to identify the specific logical tables and hierarchies that you need to include in your business model.