Incremental Publish in EP

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.

Continue reading →

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 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 […]

Continue reading →

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 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 […]

Continue reading →

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 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 […]

Continue reading →