Category Archives: cognos

Cognos BI and MS SQL — not meant for each other?

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

A couple of small, but oh-so vital Cognos Enterprise Planning Enchancements

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

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

More on choosing Dimension for Publish

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

Cognos FM: CVS problems

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

Speeding up Contributor publish

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

Admin Links from Package troubles

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

Enterprise PLanning Objects Naming Convention.

As I’ve promised, here are naming conventions I tend to follow in EP projects.
Setting up naming rules doesn’t seem so crucial at project start, but generally hits on you on the head on final phase, when development turns to support. And trying to support your colleagues model will leave you thinking about naming objects the [...]

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

A simple enchancement for Cognos 8 BI

I just thought that it’d be nice to have a built-in url shortener (like tinyurl or is.gd) for Cognos Reports.
It’s not always possible to apply html tags while sending a report link to a colleague, so such a simple thing would help me a lot.
Such an url shortener can be added as an external j2ee [...]

FireStats icon Powered by FireStats