Archive for January, 2009
Posted by jason on January 27th, 2009 under automation, essbase, maxl Tags: automation, maxl •
No Comments
Did you know that you don’t have to run your MaxL automation on the Essbase server itself? Of course, there is nothing wrong with running your Essbase automation on the server: network delays are less of a concern, it’s one less server to worry about, and in many ways, it’s just simpler. But perhaps you [...]
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 22nd, 2009 under dodeca, quick tips Tags: dodeca •
No Comments
I’m a Firefox man. I’ve been a fan since version 1.5, liked version 2 (even though it was a memory pig), and I am quite happy with 3.0. I am eagerly looking forward to some of the memory optimization and performance improvements that are coming down the pipe with 3.1. I even look to Firefox [...]
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 20th, 2009 under essbase, performance Tags: aso, essbase, outline, performance •
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, [...]
Posted by jason on January 18th, 2009 under essbase •
No Comments
Sometimes you need to delete an Application but you can’t. You still see it in Essbase Administration Services or even Application Manager (hey, there’s nothing wrong with still being on 6.5.x, if it ain’t broke…), but the app is broken or doesn’t exist. The simplest cause of this is that someone [probably you] deleted the [...]
Posted by jason on January 16th, 2009 under essbase, quick tips •
No Comments
I got a question from a reader about how to do this. Specifically, they were copying an application from one server to another and everything seemed to be going fine, except that there was no data in the resultant database on the target server. The reason for this is that when you copy Essbase apps [...]
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 8th, 2009 under essbase •
No Comments
I was going through some papers today and I happened to come across a sheet of my notes that I jotted down while I was at ODTUG in New Orleans last year (the best Hyperion conference around, seriously). Coincidentally, earlier in the day I also had a conversation with a colleague of mine who works [...]
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 [...]