Rollup Joins in Cube Blending Datasets at Runtime
In this video, we will explore rollup joins in Cube, focusing on their definition, use cases, and a quick demonstration. A rollup is a pre-aggregation of dimensions and measures that are saved or materialized in Cube's caching layer, Cube Store. Rollup joins allow us to perform joins between two rollups already in Cube Store, without materializing the join operation.
This video will cover two main use cases: multi-data source join or blend, and handling tables that update at different frequencies. Joining data from multiple databases or maintaining user entitlements tables are also discussed. The demonstration showcases how rollup joins can be used to accelerate query performance by combining data from different sources.