We’ve encountered an annoying Cognos 8 bug recently.
Usual scenario if you’re creating reports over Enterprise Planning data includes “unioning” data from several applications.
For example, you have an Operating Expenditures planning application and a Sales Planning application. To make a simple P&L, you just have to show up data from both these applications. So you can [...]
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) — [...]
Why am I writing this?
Well, sometime it helped and we now have allocation tables in administration links. Although I’m sure my post didn’t have any impact, some deem hope remains
I’m going to repost this into Communities and into Insight. And, maybe, we can create some noise by voting for these enchancements in Insight aka registering [...]
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 [...]
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 [...]
I’m not dead, just trying to push it through to my vacation. Lot’s of small news, like ‘I’ve attached cognos to essbase cubes and they work together like charm, I’m impressed’, but no time to write it out.
Anyway. I’ll be spending next couple of weeks in Europe, so if you want to share a beer [...]
I already wrote some notes on choosing dimension for publish in this post.
Today I just want to add some of points:
1 If you’re up to publishing some serious amount of data, variant with adding a dummy dlist with 1 item and using it as dimension for publish seems a very bad idea. You’re terribly slowing [...]
If you’re using CVS for your Cognos Framework manager models (and I recommend to do that, it’s essential as multi-developer and backup_to_point tool), you can encounter the problem I’ve met today.
Something went wrong during checkout on one machine and model became marked as “checked out” prohibiting further changes. With no way to toggle undo check [...]
2 excellent Proven Practices documents were published today, describing how to speed up publising (cognos.com login is required):
- using oracle
- using ms sql server
Same old “If you are loading data, drop indexes” roams
A lot of work stops me from investigating it further, but I’ve experienced some errors in admin links (dlinks) from cognos package when data contained double qoutes (”).
I guess, this is due to the fact that package links generate an xml mapping file (source to destination) which contains lines like
and this file is then [...]