Archive for the 'BI&CPM' Category

New Cognos Planning is finally out

July 31st, 2008

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

Cognos Forum podcasts

May 16th, 2008

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 )

April 1st, 2008

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

March 20th, 2008

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

March 12th, 2008

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

February 1st, 2008

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

Calculating trend lines in Cognos Report Studio and Oracle SQL

January 25th, 2008

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

Some link dumping

January 9th, 2008

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

Oracle Data Integrator + Jython : How to drop all indexes on table

November 29th, 2007

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

Adaytum is back home, IBM buys Cognos

November 15th, 2007

There’s a story I’d like to tell, especially funny in context with recent merger. I’ve found all this stuff (see links) about a year ago and I imagined the undocumented parts, it’s not official. In deep 90s a great guy named George Kunzle lead the development of IBM internal budgeting system, called FREGI. It was [...]

« Prev - Next »