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.
AGO Function on Large Databases
- jim wood
- Site Admin
- Posts: 3544
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: TM1 10.2.2
- Excel Version: 2007
- Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
- Contact:
AGO Function on Large Databases
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1