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 re...
Category: tips
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 ...
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...
Incremental Publish in EP
Just found an excellent option “Table-only Publish Post-GTP” that detects changes that make incremental publish incompatible and republishes applica...
EP TimeScale Dimension
Just a rule to follow. Create time dimension so that detail item iids are consistent\meaningful and then add all summary items. So then in common Months dlist y...
Cognos Enterprise Planning Design principles
Usually these are the signs of coming disaster in an EP system: 1) too many dlists of the same “dimension”, some elements thrown out for cutting vol...
Cognos “Real-time” Reporting on Contributor Data
8.2 makes many things nice&simple. To get a full budget report we need to do the following: 1) Publish the whole application &n...
@Transform
I’m just pointing it out again — @Transform is a wonderful BiF, allowing to calculate trigonometric functions, exponentials and logs. If only weR...
Analyst Break-Back Rules
After examining Palo source code to see how their “Splashing” works, I got interested in the rules of break-back in Cognos EP. Not satisfied with va...
Batch for log gathering + timestamping
When gathering logs, or performing backups, it’s useful to append date suffix to the result file. But that’s all not so trivial calculating such suf...