Designing universe with aggregate tables.
I have a question on aggregate tables.
If we have two aggregate tables (monthly and yearly) for a daily fact table. Do we require to join these aggregate tables with dimensions or leave it standalone ?
I saw in best practices that we need to join the aggregate table as well? If we join the dim tables, do we require to create context for each aggregation to avoid loops?
In efashion sample, they were not joined..