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...
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...
Just a quick tip — this setting is stored in “lastPublishCM” property of fm.ini file Gave me some trouble recently, when language changes led ...
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...
Just found an excellent option “Table-only Publish Post-GTP” that detects changes that make incremental publish incompatible and republishes applica...
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...
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...
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...
I’m just pointing it out again — @Transform is a wonderful BiF, allowing to calculate trigonometric functions, exponentials and logs. If only weR...
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...
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...