Join Awareness

Introduction

In many other BI platforms, Aggregate Awareness is limited to working with dimensions within the pre-aggregated tables only. In Holistics, Aggregate Awareness is smart enough to perform aggregations with dimensions that can be retrieved via a relational join.

For example, in the below example, the table aggr_movie_rating_count can be utilized even when you query "ratings by title", "ratings by genre", or "ratings by director", because those can be retrieved via a join query using movie_id.

PreAggregate aggr_movie_ratings_count {
  dimension movie_id {
    for: r(movies.id)
  }
  measure count_rating { ... }
  persistence: { ... }
}

Querying "Count of ratings by Movie Genre" will join aggr_movie_rating_count with movies table on movie_id:

Note: The aggregation will be activated if the pre-aggregate.

contains the foreign key of a Many-to-One relationship
and is on the "Many" side of that relationship

Introduction​

Video tutorial​

Introduction

Video tutorial