Archive for the ‘sql’ 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 [...]

Essbase and SQL Server Express: just don’t

Posted by jason on January 26th, 2009 under essbase, quick tips, sql Tags: , , ,  •  6 Comments

I’m working on a writeup on how to get a fully functional Essbase server up and running in a virtual machine (using Sun VirtualBox).  I’m currently working on the steps — setting up the Essbase funtionality is relatively straightforward, although you need a relational database to store various information. “No problem,” I thought to myself, [...]

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

An Introduction Essbase Integration Services (EIS)

Posted by jason on January 15th, 2009 under eis, essbase, sql  •  1 Comment

So, just what is this EIS thing?  You’ve heard about it, you know it has something to do with outlines, but you haven’t used it and you just don’t know where to start.  I understand.  I’ve been there.  I couldn’t really see an immediate payoff to using it, which kind of made getting all setup [...]

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

Normalize a fact table for a better EIS model

Posted by jason on February 1st, 2008 under eis, essbase, sql Tags: ,  •  No Comments

Generally I don’t load data through EIS because quite honestly, I fudged some of the EIS models when I first made them and now I’m pretty much married to them.  They are perfect for loading the outlines, but not data.  Earlier this week I was playing around with one of my newer models, trying to [...]