AGO Function on Large Databases

Post Reply
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

AGO Function on Large Databases

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply