Dating dims


I have a scenario I'm working through that looks something like this: I have 2 tables (in practice way more than 2 tables) that entail GA site analytics that are both joined with a content items dimensions table and each with a date dimension.One fact table, with aggregated metrics, looks like this: Treating cms_id as a consolidated dimension works great because I can specify that both of these tables join with my content items table on that cms_id, and that's fine.But I don't have a corresponding dimension table for dates!



This is great from a query standpoint, but I totally understand your concern with this method from a data size standpoint.

If this becomes a problem in the future, you could go back to using the generating_series function.