My user base has about 150 Pplay reports (large department) all pointing to cubes on the network. These reports are many years old so Pplay, the cubes and the reports are well entrenched.
I want to move the cubes to a different folder. How can I get a pplay report to point to the new location? Worse case I have to do each report one-by-one but if it can be done with script/code then even better (I'm a developer).
I just don't know PPlay well enough to workout how to point a report to a different cube. Please don't tell me the report needs to be rebuilt. :(
In the open dialogue there's a "prompt for cube" checkbox to the right, check it and then show the report the new .mdc location.
This could probably be scripted (CognosScript macro) but I don't know what would be involved in deploying/executing it, it might not be worth the trouble.
(sorry, I overlooked this post or would have answered sooner)
I found out if you remove or change the cube location then the PPlay explorer/reporter will also prompt for the cube location.
Your suggestion is much better but. :)