Dimension Awareness

Introduction

This is the most basic use case of aggregate awareness.

Once you defined your pre-aggregates with specific dimensions, Holistics can automatically substitute pre-aggregates with accurate dimensions and granularity into your queries.

For example, Holistics will automatically use the pre-aggregated table agg_transactions to answer all of these below queries instead of the raw_transactions table.

• Count transactions by day and status
• Count transactions by day, status, and country
• Count transactions by day, status, country, and city
• etc.