Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Designing universe with aggregate tables.

Hi Experts,

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?

Please suggest..

In efashion sample, they were not joined..

Thanks

Pavani.

Former Member
Not what you were looking for? View more on this topic or Ask a question