# Semantic Layer

> One place that sets the rule for each number. Every tool gets the same answer.

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** Metrics Layer, Metrics Store, Semantic Model, Universal Semantic Layer

## Think of it like

It is like one word list that all the classes in a school use. A word means the same in every room.

## Definition

A semantic layer sits between the warehouse and the tools that read it. It defines business numbers once, such as revenue or active users. It also names the fields people group by, such as country or month. Every tool that asks for revenue gets the same answer, worked out the same way. The layer turns each request into SQL.

## Example

Revenue is set once as paid orders minus refunds. The dashboard, the sheet and the AI helper all show the same figure.

## Why it matters

Without it, each tool and each analyst writes revenue their own way. The numbers drift apart, and trust goes.

## Common mistake

Trying to define every number on day one. Start with the ten that people argue about most.

## Three principles

- **Define once.** Each number has one rule.
- **Many tools.** Dashboards, sheets and assistants.
- **Writes the SQL.** Turns requests into queries.

## Related terms

- [Measure (Analytics)](https://learn.benibix.com/term/data/measure)
- [LookML](https://learn.benibix.com/term/data/lookml)
- [Business Glossary](https://learn.benibix.com/term/data/business-glossary)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [OLAP Cube](https://learn.benibix.com/term/data/olap-cube)

## Told apart from

- [Semantic Layer vs Business Glossary](https://learn.benibix.com/compare/semantic-layer-vs-business-glossary): People think a semantic layer is just a business glossary. A glossary explains a word like revenue in plain words. People read it. A semantic layer sets out revenue in code that tools run. It turns the rule into SQL and gives back the number. One says what revenue means. The other works it out.

![Warehouse tables on the left feed a semantic layer in the middle, which holds one definition of revenue as the sum of amount, plus dimensions for country and month. Three tools on the right, a dashboard, a spreadsheet and an AI assistant, all ask for revenue and all get the same number.](https://learn.benibix.com/diagrams/semantic-layer.svg)

---

Source: https://learn.benibix.com/term/data/semantic-layer
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
