Archive for the ‘sql’ Category
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 [...]
Posted by jason on January 26th, 2009 under essbase, quick tips, sql Tags: essbase, installation, pain, sql •
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, [...]
Posted by jason on January 20th, 2009 under automation, essbase, performance, sql Tags: essbase, optimization, performance, profiling •
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 [...]
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 [...]
Posted by jason on January 6th, 2009 under automation, dodeca, essbase, maxl, quick tips, sql Tags: autoation, calc, essbase, load, maxl, optimization, report •
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 [...]
Posted by jason on February 1st, 2008 under eis, essbase, sql Tags: eis, essbase •
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 [...]