COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: James111 on 25 Feb 2010 08:11:05 AM

Title: PCactivate issue
Post by: James111 on 25 Feb 2010 08:11:05 AM
Hey,
I'm using pcactivate in a batch file to create a new version for my powercube, just like in this example:
http://www-01.ibm.com/support/docview.wss?uid=swg21389316

The problem is, that unlike manually choosing "Copy And Activate the PowerCube" in the transformer power cube list, the old versions of the power cube are not being deleted by the batch file so I'm left with a bunch of old, irrelevant data.

Any ideas?
Title: Re: PCactivate issue
Post by: MFGF on 25 Feb 2010 10:39:05 AM
Hi James,

That is deliberate on IBM's part - so that if the new cube is corrupt or incorrect, you can easily swap back to a previous version by simply changing the version file name.

Since the cubes are in folders with date-time stamped folder names, you could probably come up with some clever batch command to search for and kill any folders more than (say) two days old.  I'm not a batch file expert though - sorry.

Regards,

MF.
Title: Re: PCactivate issue
Post by: James111 on 01 Mar 2010 12:44:20 AM
But in Transformer you can choose a maximum number of old cubes to keep. Isn't there a way to do the same with the pcactivate command?