Page 1 of 1

AGO Function on Large Databases

Posted: Tue Mar 09, 2010 8:43 am
by jim wood
Guys,

While the AGO function works well when using a valid calendar dimension, the SQL it generates is not very efficient. If you are working with a large database that you are not able to aggregate then you may want to look at an alternative. We added a previous column to our calendar view and linked the previous (say week) measures to that calendar instead. We have noticed a large improvment in performance.

I must stress that AGO does work well on smaller aggregated tables,

Jim.