If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Scripting cube deployment

Started by t1701, 22 Dec 2012 02:44:13 PM

Previous topic - Next topic

t1701

I'm looking at the Cognos 10 transformer. You can specify the folder names in the model that you want to deploy the cubes to.
Nice idea. My question is, can the deployment folders be scripted and not "hard-coded" into the transformer model.
We build the cubes on one server and deploy to another.
When we move the models from Dev to QA to Prod, I don't want to keep changing the model because of the deployment folders.
I should be able to script where to deploy the cubes too.
Any suggestions?

t1701

I think I found my solution with pcactivate. I cen script what folders to deploy to and have different folders depending on if it's on a DEV server or Prod server.
The only issue I have now is that pcactivate leaves the old mdc file.
I'll need a way to remove the previous days folder after the activate.

bdbits

Just an idea... You could use a mapped drive to specify the destination. In each environment, the mapped drive will point to the appropriate target location, and since you use the mapped drive on the deployment tab the model does not need to be changed.