Category Archives: BI&CPM

Essbase book

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

Essbase first impressions

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

New Cognos Planning is finally out

With so-long waited new Contributor client, with expand\collapse and nest dimensions features. And a lot, lot more. ActiveX free ) Actually, as long as I’m with cognos ep (since adaytum 2.4), contributor was always the same good-old-rigid tool, so it’s a revolution indeed.
Well, with a huge lot of bugs inside, it’s time, gentlemen, to power [...]

Cognos Forum podcasts

All thanks to Shawn Rogers for recording.
Rob Ashe Interview
Southwestern Energy Company
CFO at the US Army’s Armament Research Development and Engineering Center (ARDEC)
Last “Cognos-only” forum, they say. Next will be more IBMish.
And they didn’t invite me

Using Oracle Model clause in real-life )

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

Panorama integrates in Google Docs to provide BI capabilities

This is really great. For Panorama, in my opinion. Getting up a giant user-base accustomed to their tools, getting a huge attention.
Where was Cognos IBM, one wonders
Official links
Panorama blog comments

Future Oracle BI Architecture by Rittman

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

Ways of calculating Running Count to import data into Multi-Line models

I’ve nicked the term “Multi-Line” model out from some cognos best practices presentations. Never known it was called that way )
Multi-Line is only way to go when you have a potentially huge dimension only a tiny bit of which should be available to end-user at a time. Like employee planning, whole dimension of 10k people, [...]

Calculating trend lines in Cognos Report Studio and Oracle SQL

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 of the Cognos [...]

Some link dumping

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

FireStats icon Powered by FireStats