Posts Tagged ‘optimization’

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 [...]

MaxL Essbase automation patterns: moving data from one cube to another

Posted by jason on January 6th, 2009 under automation, dodeca, essbase, maxl, quick tips, sql Tags: , , , , , ,  •  No Comments

A very common task for Essbase automation is to move data from one cube to another.  There are a number of reasons you may want or need to do this.  One, you may have a cube that has detailed data and another cube with higher level data, and you want to move the sums or [...]

Optimizing Essbase Automation Jobs (for fun and profit!) – Part 1

Posted by jason on November 21st, 2008 under essbase Tags: , ,  •  No Comments

I freely submit that I am a complete geek.  But it’s okay, because I have come to accept and embrace that inner geek.  Anyway… Many organizations run jobs to perform a task as certain intervals.  Your job as a good Essbase/Hyperion administrator is to be lazy — that is, make the computers do the boring [...]

Jason’s Top 10 Essbase Data Load Optimization Tips

Posted by jason on November 18th, 2008 under essbase Tags: ,  •  No Comments

I received an email today from someone looking to speed up their data loads, specifically their ASO data loads that seem to be taking too long.  This is, of course, an important topic for many Essbase cube wranglers.  I would be willing to bet that many people spend more time optimizing calcs and may even [...]