PowerMetrics Adds Support for Cube Semantic Layer

From Cube Semantic Layer and data warehouses that store their gold-standard corporate data, to cloud service APIs, on-premise systems, and spreadsheets, data teams are increasingly tasked with building a future-proof metrics strategy that evolves alongside their data infrastructure.

What are Cube metrics?

Cube is a popular universal semantic layer that helps give meaning to data and makes it accessible to everyone. Data engineers and application developers use Cube’s developer-friendly platform to organize data from their cloud data warehouses into centralized, consistent definitions, and deliver it to every downstream tool via its APIs. PowerMetrics connects directly to Cube Cloud, synchronizes with the data in a cube, and associates it with a metric definition for visualization.

Cube metrics do not store data in PowerMetrics. Instead, they define the necessary transformations from their metric query language into SQL against the data directly in supported data warehouses, query engines, and databases, such as Microsoft Fabric, ClickHouse, MotherDuck, and Trino, in addition to, Snowflake, Google BigQuery, Databricks, and Redshift.

Our new Cube integration enables:

• Data teams to define metrics from cubes directly in PowerMetrics
• Full support for Cube's two-level caching system (in-memory and pre-aggregations)
• PowerMetrics to update as soon as the underlying cube data changes via a webhook
• Cube metrics to be used in calculations and within the PowerMetrics metric catalog and combined with metrics using other data strategies, such as data warehouse, data feeds, and instant metrics.
• Business users to explore, analyze, visualize, share, and build dashboards using Cube-based metrics

Data teams create and curate the metric catalog. Business users access and explore metrics in the catalog without assistance from the data team. That's the true power of PowerMetrics.

How do data warehouse metrics and Cube metrics work in PowerMetrics?

PowerMetrics enables you to create metrics from data, and from calculations based on other metrics. No matter the underlying metric type, PowerMetrics provides a consistent and rich set of capabilities. Data warehouse and Cube metrics work naturally alongside metrics based on data feeds, providing a comprehensive, seamless user experience.

In PowerMetrics, you can set up a connection to access data from a data warehouse or from Cube with a valid environment id and token. After entering these credentials, you’ll be presented with a list of available tables, views, or cubes. Next, you select a measure, configure dimensions, and choose the date field to use for the metric. Additional properties, such as the value format, metric value trending up is positive/negative, etc. can also be set. When you’re happy with the settings, save the metric. It’s automatically added to your metric catalog.

Ensuring changes to data warehouse and Cube metrics are reflected in PowerMetrics

As data is added to a data warehouse table or a cube, changes to your metrics are reflected in PowerMetrics so everyone sees the latest version of the data. A webhook can be set up to notify PowerMetrics when there’s new data to consume, keeping metrics and metadata in sync. 

Level up data-driven decision making

Make metric analysis easy for everyone

Get Started Now

Get started today

Connect Cube today, create and curate metrics, and enable self-serve analysis, visualization, and dashboard creation for your business users. This new integrations is available now.

Let PowerMetrics help you streamline your analytics journey and ensure your metrics strategy remains adaptable and resilient. Try it for yourself and we look forward to your feedback!