Skip to content

Category Archives: ibm

Using session variables in Cognos BI

Just a quick Cognos BI hint: you can use session variables to store project-level constant values. I’m a big fan of ‘feature-rich’ ETL reports showing not only what dimension element mismatch between systems, but also allowing seamless editing of element mapping. This usually means drilling down from report into external application for dimension mapping. Parameters [...]

Posted 22 August 2011 † ykud § bi § etl ‡ Comments (0) °

New Cognos BI and TM1 content from IBM

Cognos 10 Redbook is now avalaible on IBM site. I always respected RedBooks initiative, because these are actual books with lots of practical knowledge, not just product documentation. I’ve only skimmed through this book, it seems less tips’n’tricks than Packt one about Cognos 8 Report Studio. But it’s a very good overall coverage of what [...]

Posted 09 April 2011 † ykud § bi § tm1 ‡ Comments (0) °

Oracle BI Enterprise Edition vs Cognos BI

Since I’ve spent some time working with Oracle Business Intelligence last year, I think I’d write a simple comparison list of strengths\weaknesess of OraBI EE vs Cognos (see post on the same topic by Venkatakrishnan). All of this is imho, of course. Oracle BI EE Pro’s: 1) Aggregate navigation – ability to set up aggregate [...]

Posted 01 February 2010 † ykud § bi § cognos § essbase § oracle ‡ Comments (3) °

Memory leaking in Cognos 8.3 BI

You know why i’ve started this blog in the first place? To get advice, of course. And today DesiCresnet shared a wonderfull piece of information concerning memory troubles in BI 8.3. Those who aren’t struck by occasional CAM-AAA-0071 “An internal error occurred” which stops the whole server can skip this post. This error was discussed [...]

Posted 20 October 2009 † ykud § bi § cognos ‡ Comments (6) °

Cognos 8 EP troubleshooting import data from package

Tip of the day: Having common metadata layer for BI and Enterprise Planning is really cool, especially with the ability to load data from BI packages to EP via links. Just that it sometimes doesn’t work. But there are always some workarounds. With mostly very cryptical error messages or without any. One of the problems [...]

Posted 06 August 2009 † ykud § cognos § ep cookbook ‡ Comments (3) ° Tagged: ,

Back from winter-sleep

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

Posted 01 March 2009 † ykud § bi § BI&CPM § blogging § cognos § ep § hyperion § oracle ‡ Comments (2) ° Tagged: , , , , , ,

Adaytum is back home, IBM buys Cognos

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

Posted 15 November 2007 † ykud § BI&CPM § cognos ‡ Comments (1) ° Tagged: , ,