Semantic Layer Guide - Architecture, Logic, and Operations

Measures and Metrics

The quantitative building blocks and finalized calculations exposed to consumers. Measures define the direct aggregations; metrics wrap them in precise business logic.

In practice

Applying a SUM() on an order_amount column (measure) to calculate the finalized “Total Revenue” (metric).

Relationships and Topology

Explicitly map how distinct entities and tables connect, governing exactly how joins are generated to navigate schemas and prevent fan-out traps.

In practice

Declaring a many-to-one relationship from orders.customer_id to customers.id.

Governance and Policy Rules

Centralize security and data access constraints at the query compilation layer, ensuring policies are enforced identically across all downstream tools.

In practice

Applying Row-Level Security (RLS) to restrict sales data to a specific regional manager.

Semantic Layer Guide © Scalefree International GmbH 2026

12

Powered by