I must be the last one to notice, but you can actually try out Cognos 10.1 BI and Cognos Express for free (time limited trial). That’s very convenient and is totally a major shift from usual ‘we have products soooo good that you have to ask partners to show them’ policy. ‘Open download and use [...]
A check-list for using Microsoft SQL Server as a reporting database. This is a ‘be aware’ list for myself in first place, since I forget some details as time passes. Table of contents Overall database settings Table configuration ETL Query tuning Books to read Overall database settings Use simple recovery mode Set up simple recovery [...]
Just a quick hint and a reminder: there is a configuration option forcing Cognos to store temporary report results in memory rather than dropping them on disk. It’s especially usefull for DMR’s they are frequently cached on disk. Quote from Architecture and Deployment Guide. Depending on the size of reports and the amount of available [...]
Finally got my hands to installing and trying it. Well, it looks nice, allows flash-based chart formating and turns Cognos portal pages into more dynamic “dashboards”. But it’s strangely slow (tried on a couple of computers) and all in all looks kinda “alpha” and plugged in at last moment. Installation is not that easy too, [...]
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.A) [...]
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 ) Changing this file helped. Found via FileMonitor from sysinternals, as usual.
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 [...]
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 [...]
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 [...]
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 [...]