Skip to content

Tag Archives: scripts

Analysis Studio Cube Swapping

After creating cube in Transformer you place on Cognos 8 as a data source, to allow everyone to access it. But since the reading process of Cognos 8Bi opens mdc cube file on file level, it locks and the problem of updates arises. No way to update a cube while it’s locked. There are two [...]

Posted 22 January 2007 † ykud § bi § cognos ‡ Comments (0) ° Also tagged: , , ,

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

Posted 05 December 2006 † ykud § coding § cognos § tips ‡ Comments (0) ° Also tagged:

Server-Side ASP Sleep

While implementing an idea of web-based execution of Contributor Macros (see previous post), I’ve encountered the problem of some kind of progress-bar drawing in asp page. When user hit’s asp page calling a Contributor Macro (which can take 15 min), he ought to see some action, telling him that “work is still going”. Mine idea [...]

Posted 08 September 2006 † ykud § BI&CPM § coding ‡ Comments (2) ° Also tagged:

Remote macro execution

Since Analyst and Contrib macros are typically packed into .bat files, remote bat execution is a common task. If you don’t want user to access server via terminal session of some sort, but user still needs to start some administrative task (data transfer, reconciliation or such) remote execution comes into play. There are 3 basic [...]

Posted 04 September 2006 † ykud § BI&CPM § coding ‡ Comments (1) ° Also tagged: , , ,