Powered by Cube.jsThe Metric Store is built on Cube.js, the leading open-source semantic layer platform. We’ve integrated it deeply with the 5X platform to provide seamless project management, deployment options, and BI tool integration.
What are cubes?
Cubes are pre-built data models that contain:- Measures: Quantitative metrics like revenue, orders, users, or any calculated business KPIs
- Dimensions: Attributes for analysis like date, region, product category, or customer segment
- Time dimensions: Special dimensions for time-based analysis and period-over-period comparisons
Core capabilities
Project management
Create and manage multiple Cube projects with Git-based version control:- Platform managed repositories - 5X-managed Git repositories for easy setup
- Imported repositories - Connect your existing GitHub repositories
- Branch management - Work with multiple branches for different environments or features
- Project settings - Configure deployment options, protected branches, and environments
Cube Playground
Interactive development environment for building and testing cubes:- Visual query builder - Drag-and-drop interface for building queries
- SQL editor - Direct SQL query execution and testing
- Data exploration - Explore cubes, measures, and dimensions interactively
- Schema management - Define and edit cube schemas using YAML or JavaScript
API access
Query your cubes through multiple interfaces:- SQL API - PostgreSQL-compatible connection for BI tools and SQL clients
- REST API - RESTful API access for application integration
- Real-time calculations - Compute metrics on-demand with fresh data
- Connection credentials - Secure, managed credentials for API access
BI integration
Automatically sync cube definitions with BI tools:- Native connectors - Support for Tableau, Power BI, Looker, and more
- Automatic synchronization - Keep metric definitions current across tools
- Individual or bulk sync - Sync specific connections or all at once
- Status tracking - Monitor sync status and last sync time per connection
Deployment options
Configure when your Cube service runs:- Always on - Continuous operation for production environments
- On demand - Start when needed for development or testing
- Scheduled - Time-based or cron-based scheduling for specific hours
Getting started
Ready to create your first Cube project? Here’s how to get started:Step 1: Navigate to Metric Store
- Go to the Metric Store page (
/metrics-store) - Or click “Metric Store” from the navigation menu
Step 2: Create your first project
If no projects exist, you’ll see a “Create project” button. Otherwise, use the project dropdown and select “New project”.Getting Started Guide
Quick start in 5 minutesStep-by-step guide to creating your first Cube project and defining your first cubes.
Core documentation
Explore the comprehensive guides to master the Metric Store:Getting Started
Create your first projectQuick start guide to creating your first Cube project and accessing the Cube Playground.
Project Management
Manage projects and branchesLearn how to create, edit, and manage Cube projects with Git-based version control.
Cube Playground
Build and test cubesMaster the Cube Playground interface for building queries and defining cube schemas.
API Credentials
Access your dataLearn how to get SQL and REST API credentials for connecting BI tools and applications.
BI Integration
Sync with BI toolsSet up automatic synchronization of cube definitions with your BI tools.
Deployment Options
Configure deploymentUnderstand deployment modes and scheduling options for your Cube service.
Key benefits
Single source of truth
Define business metrics once in Cube schemas and use them consistently across all your analytics tools. Eliminate discrepancies between different reports and dashboards.Flexible development workflow
- Git-based version control - Track changes, collaborate, and manage cube definitions
- Branch-based development - Work on features in separate branches
- Schema as code - Define cubes using YAML or JavaScript files
- Testing and validation - Test queries in Cube Playground before deploying
Universal access
Make your cubes available through multiple interfaces:- SQL API - Connect any SQL-compatible tool or client
- REST API - Integrate with custom applications
- BI tools - Native connectors for popular analytics platforms
- Real-time queries - Compute metrics on-demand with current data
Integration with core features
The Metric Store enhances all other 5X capabilities:- Data Warehousing: Cubes query your warehouse directly for real-time calculations
- Business Intelligence: BI tools connect to Metric Store for consistent metrics
- Data & AI Apps: Applications access standardized metrics through APIs
- Conversational AI: Natural language queries use Metric Store definitions
- Orchestration: Cube projects can be managed through workflow automation
Common use cases
Executive reporting
Ensure leadership sees consistent numbers:- KPI standardization across all executive dashboards and reports
- Period-over-period analysis with consistent time-based calculations
- Goal tracking comparing actual performance to targets
- Board presentation materials with verified, consistent metrics
Self-service analytics
Empower business users with trusted metrics:- Metric discovery helping users find the right data for their questions
- Confidence in results knowing all metrics follow approved business logic
- Reduced IT burden fewer requests for custom reports and analysis
- Guided exploration suggesting relevant metrics and dimensions
Cross-functional collaboration
Enable teams to work with shared definitions:- Sales and marketing alignment on lead and conversion metrics
- Finance and operations using the same cost and efficiency calculations
- Product and engineering sharing user engagement and performance metrics
- Customer success teams accessing consistent customer health scores