Comparison Point
Legacy
True Universal
Metrics Layer
Semantic Layer
Scope of Logic
Limited to basic aggregations (e.g., SUM, COUNT) often tied to a single, flattened table.
Forms a complete business ontology, explicitly mapping entities, multidimensional hierarchies, and complex metrics.
Platform Interoperability
Tightly coupled to a specific BI tool or data warehouse environment, risking vendor lock-in.
Headless and API-first (REST, GraphQL, JDBC), serving standard metrics to any downstream application or AI agent.
Execution Architecture
Relies on static batch processing or pushing engineers to materialize fully denormalized tables (OBT).
Acts as a dynamic compiler, reading definitions to generate dialect-optimized SQL on the fly at query time.
Relational Intelligence
Struggles with complex joins, requiring users to manage relational hazards manually.
Navigates underlying schemas via semantic graph traversal, natively preventing fan-out and chasm traps.
Governance Enforcement
Applies security controls (like Row- Level Security) only within the specific visualization application.
Centralizes policies within the compiler, enforcing access rules universally across all downstream endpoints
To combat the fragmentation caused by proprietary vendor definitions, the industry is moving toward standardized semantic contracts. The Apache Ossie (formerly known as Open Semantic Interchange) represents a push for interoperability, allowing organizations to define metrics in a vendor- neutral format. In this paradigm, OSI acts as the portable semantic contract, while engines like dbt’s MetricFlow act as the semantic runtime. MetricFlow ingests the OSI definitions, performs the necessary graph traversal, and executes the SQL generation. This separation of definition from execution protects organizations from future vendor lock-in while maintaining high- performance query compilation.
Semantic Layer Guide © Scalefree International GmbH 2026
10
Powered by FlippingBook