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.
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 [...]
Just found an excellent option “Table-only Publish Post-GTP” that detects changes that make incremental publish incompatible and republishes application. It should be set to “Yes” by default, imho. See how incremental publish can streamline your reporting in these posts: 1, 2.
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 you’d get 1-12 for months, 13 for “1 Quater”, 14 for “2nd Quater” and so on. That will allow you to use simple time arithmetics in dlist formated [...]
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 volumes, calculating or not calculating smth, and you have all seen them laying around just because they seemed to consistent at the time of creation. 2) manually maintained access [...]
8.2 makes many things nice&simple. To get a full budget report we need to do the following: 1) Publish the whole application 2) Run the report on published data Publishing a typical application of 100+ elist takes around 20 minutes, so no real-time here. But 8.2 introduces trickle publish, allowing to incrementally publish only changed [...]
I’m just pointing it out again — @Transform is a wonderful BiF, allowing to calculate trigonometric functions, exponentials and logs. If only we’d use them often.
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 vague description in Analyst User Guide and performing some test and calculations, I’ve received following results. Break-Back calculates only on Sum\Substract\Multiply\Division, not on IF-ELSE, or BIFs. Here are formulas for [...]
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 suffix in pure bat-files. We’ll use system variables %date% and %time%. Try executing “echo %date%” and “echo %time%” from command line and watch the output. We’ll append date suffix, and will [...]