To see how these core components interact in practice, consider this vendor- agnostic YAML configuration based on the Open Semantic Interchange (OSI) standard (now hosted as Apache Ossie). Rather than locking definitions into a proprietary platform, this declarative approach explicitly maps the datasets, constructs the relational topology connecting them, and defines standardized metrics that any compliant engine can execute:
YAML
semantic_model: - name: ecommerce_analytics description: Core E-commerce analytics model for the enterprise datasets: - name: orders source: sales.public.orders primary_key: [order_id] fields: - name: customer_id expression: - dialect: ANSI_SQL expression: customer_id - name: customers source: sales.public.customers primary_key: [id] relationships: - name: orders_to_customers
from: orders to: customers from_columns: [customer_id] to_columns: [id]
metrics: - name: total_revenue description: Total revenue across all orders expression: - dialect: ANSI_SQL expression: SUM(orders.amount)
Semantic Layer Guide © Scalefree International GmbH 2026
13
Powered by FlippingBook