metric-creation

To define business metrics in a semantic layer, you anchor reusable aggregations to specific entities using guided SQL expression building, ensuring a single source of truth for KPIs across all dashboards and reports.

You can create various metric types using SQL aggregation, including basic, derived, filtered, ratio, count, and text summarization metrics, all anchored to entities within your semantic layer for consistent reporting.

You can manage and update existing KPI definitions using MCP tools to create, update, or delete metric objects, ensuring your semantic layer reflects the latest business logic and SQL expressions.

The best way to maintain a single source of truth for KPIs is to define them as reusable aggregations anchored to entities in a semantic layer, preventing inconsistent calculations across different dashboards and reports.

Yes, you can build derived and ratio metrics from existing aggregations by using SQL expression building to combine or filter base metrics, allowing for complex business performance calculations within the semantic layer.