Archive for November, 2008

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

A MaxL quickie to unload those databases that are eating your precious memory

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

Due to various business requirements, some organizations end up archiving many of their cubes each year.  For example, if you have a huge Measures dimension that is constantly changing (even in subtle ways), but you need to be able to go back at some point in the future and see what some numbers looked like [...]

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

I submitted two abstracts for ODTUG!

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

Last year in New Orleans, the Hyperion track at ODTUG was an unqualified success.  It was such a success, in fact, that hundreds of abstracts were submitted for next years conference in Monterey.  I submitted two of those, so wish me luck.  I’d like to talk about an end-to-end Essbase automation system profiling/performance/optimization effort which [...]

The Essbase Spreadsheet Automation Trick

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

This one is a bit of a blast from the past.  And I mean that — the timestamp on this file is over five years ago.  You may have heard people refer to this method.  If you’ve ever found yourself getting confused over what-job-runs-when-and-on-what, then this might be a technique that works for you.  Obviously, [...]