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?
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.
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.