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 FlippingBook