Archive for the ‘performance’ Category

A comprehensive Essbase automation optimization story, or: Shaving off every last second

Posted by jason on August 5th, 2009 under automation, essbase, maxl, performance, sql  •  3 Comments

I’ve been wanting to write this post for awhile.  Like, for months.  Some time ago I took an in-depth look at profiling the performance (duration-wise) of an automated system I have.  The system works great, it’s worked great, I don’t need to touch it, it just does its thing.  This is the funny thing about [...]

An Essbase Optimization Story

Posted by jason on June 16th, 2009 under essbase, performance Tags: , ,  •  1 Comment

I got a call the other day from one of my fellow Essbase developers. One of the cubes in their budgeting system was taking a long time to finish calculations, whereas just days before the calculation time was just fine.  I have an almost unhealthy obsession with cube performance and optimization, so I jumped in [...]

Essbase Performance Optimization: it’s not just the calc script

Posted by jason on January 20th, 2009 under automation, essbase, performance, sql Tags: , , ,  •  No Comments

Here’s a quick post that is a bit of a precursor to some of my more in-depth performance analysis articles that will be coming out in the future.  One of my automation systems takes a bit over an hour to run.  There are a lot of people I know that need to squeeze performance out [...]

Some performance observations changing an ASO hierarchy from Dynamic to Stored

Posted by jason on January 20th, 2009 under essbase, performance Tags: , , ,  •  No Comments

There are numerous ASO cubes among my flock.  Usually the choice to use ASO was not arrived at lightly — it was/is for very specific technical reasons.  Typically, the main reason I have for using ASO is to get the fast data loads and the ability to load oodles of noodles… I mean data.  Yes, [...]