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

Since I’ve spent a day breaking through this mess, I’d share my way of getting ODI to work with XE as a repository. ODI repository creation is sucessfull, but after that Topology Manager and all other ODI modules won’t work, throwing “ORA-12705: invalid or unknown NLS parameter value specified” while connecting to XE. There are [...]

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

I’ve been a long-term fan of oracle model by clause, talking about here and there, doing some small&funny examples (like eight queens solution in one select) but lacked some real-life necessity to use it. It always turned out that partition by was enough, or some tricky analytical function was already built-in (like trend calculations I [...]

Just in case you missed that — awesome course about on how to cook Oracle BI projects is freely available!!!

I’m more than just emotional right now since I’ve finally got that bugger of my neck. To those who’re interested in getting trend calculated in oracle — press page-down once. Trend line calculation in Cognos. It’s 2008 as my desktop calendar says and it’s “Targeted information to a broader range of users ” on top [...]

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

I’m currently building a warehouse using ODI, so I’ll share some findings as it goes. And there’s be Cognos BI on top of it and EP is one of the sources, so I’m still close to the roots ) Disclaimer: I’m Oracle & ODI n00b — there are (?) better ways of accomplishing these tasks [...]

Nice overview and details. I’d only seen cubegeek posting Hyperion-related stuff.

Well, I’m last to notice — they’ve brought all hyperion apps on edelivery.oracle.com Started unwrapping this mid-summer present today. It took me quite a time to get to Hyperion Planning LogOn screen, I must admit. This is no Analyst out-of-box experience, this is serious software with lots of ports&services stuff ) And AIX 64 capable [...]