Caching / Denormalization

[danfrankj]

If we compute "transactions by user/country" this may well involve a large join between a transactions fact table and a user dim table. If we need to re-do this large join for every query that involves measures from transactions and dimensions from user our ability to interactively query becomes prohibitively slow.