Applied dimensionality

Using this blog as offline memory. Just ignore this post, if you’re not up to Essbase ) If you’re configuring DataDirect ODBC drivers on *nix system, be aware of following: There are 2 versions of odbc.ini file, one in 32bit driver folder, other in 64. 64 essbase uses 64 drivers. You should copy required odbc.ini [...]

Yet another post on Essbase ) Internal ASO storage structure is a block box, so unlike BSO. So while Roske haven’t writen a book on ASO option, we have to wonder in the dark.  The main description of ASO storage is “data is stored as key\value pairs”. This quote comes from ASO Tuning WhitePaper, the [...]

Hm, I guess it’s the time for a first big essbase-related post. Today we’ll talk about data loading in ASO cube. Those who’ve listened to our recent Oracle events presentations (russian TechForum 2008, BI Forum 2009), know that we’ve made a nice PoC project with SportMaster, consisting of loading their year’s worth of daily stock [...]

Okay, it has been almost half-a-year (oh, dears) since the last decent post on this blog. Russian one has suffered as well, I must note. Reasons vary, but mostly it’s that I’ve been, you know, busy-busy. As I now start to reflect on it, it’s always a point of view thing and a question of [...]

Read Edward Roske and Tracy McMullen’s “Look Smarter than you are with Essbase System 9″ over the weekend. It’s really the best “technical” book I’ve read over past couple of years. Written in simple and not annoying language, with a lot of humor (I couldn’t hold myself when I’ve read the fight club joke) — [...]

Finally got a chance to try essbase out on real data volumes. Building half-a-billion facts cube turned out into something like this: PS: I have very special attitude to David Lynch’s films. A physical one. Just the sight of road running away at “Lost Highway” makes me creepy. It takes me about 5 seconds to [...]

Essbase is finally supported in Oracle BI. Hooray. From here. Cognos 8.2 BI sp1 out, gotta give it a try.