Mar 19, 2009
Cognos and MS SQL — happy together
Correcting myself. I was ranting about MS SQL and Cognos interaction. I was totally wrong.
The problem, described shortly is:
you have 2 databases in MS SQL residing on the same physical server you create a join “table A from db1 with table B from db2” Cognos creates two select queries (select * from db1.
Mar 9, 2009
Default Framework Manager package publish folder
Just a quick tip : this setting is stored in lastPublishCM property of fm.ini file
Gave me some trouble recently, when language changes led to unappropriate publish folder name. Moreover, we were not able to publish anything at all )
Mar 1, 2009
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.
Jan 27, 2009
Cognos EP Cut-down models
Just a quick tip: read this cognoise thread thoroughly — really in-depth discussion.
Sep 27, 2008
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.
Sep 16, 2008
Essbase book
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.
Sep 11, 2008
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
Jul 31, 2008
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.
Jul 5, 2008
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:
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.
Jul 1, 2008
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.