Ever found yourself wondering what users are really there in your BI Consumers or any other group? Sure, you’ve got a few of them explicitly listed there (bad practice) but mostly you’ve got just a list of other groups like “Western Division”, “Marketing” and all those (good practice). And they’re, most likely, nested into each [...]
After, oh my god, 4 years, I’ve spent a couple of days typing Cognos 10 SDK Java code. What changed in BI automating during this period? Well, the biggest change was trivial: I’ve forgot everything But that turned out to be good news, since version 8.3 to version 10 changes are huge. I remember reading SDK [...]
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 [...]
Sometimes it’s best to be late with fulfilling promises. Was I to write this post a month earlier, I wouldn’t be able to give people using Cognos BI with Microsoft Analysis Services and Oracle Essbase a life-saving advice. At least, the advice that I’d be really grateful a couple of years ago. A month [...]
If you’re a serious Cognos BI shop with Dev-Test-Prod migration and release management, you definitely have to read this Proven Practice article. Overall, proven practice articles are very good, I’ve skimmed through half a dozen of them. It seems that the easiest way to gain full article list is to filter by cognos_business_intelligence tag. This [...]
Spent half an hour sketching up Cognos process architecture — what goes where and when. Will refer to this drawing in my future hardware planning assigments Comments: You can separate all components (Gateway, Application Server, Content Manager) into separate machines There can be only one Content Manager service active in cluster at a time [...]
¶
Posted 25 June 2011
† ykud
§
‡
°
Always thought it was a joke … Up until today. Really, there is a Speed = True parameter in Transformer MDL. I adore developer’s sense of humour ) PS: There’s so much going on lately — hold on for some interesting news & posts.
¶
Posted 05 June 2011
† ykud
§
‡
°
There was yet another discussion on this topic on Cognoise, so I’ve decided to list all the variants I’m aware of in this post. What is an aggregate? One of the main ways to speed up your DWH is to use aggregate tables, so that every time you ask about monthly sales per region system [...]
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 [...]
Just a bullet list of things that separate Cognos Transformer from being a capable OLAP-tool in modern market. Neither of these problems will be solved, I think, and this will lead to Transfomer’s death in near future (about 5 years, imho, given huge userbase). That’s a pity, since it’s a nice tool, absolutely brilliant 10 [...]