Hey everyone,
I have a script that executes cube builds every night. However, not all of my users like to exit the cube after viewing it through Cognos Connection, which would result in my script not updating the cube. Are there arguments I can use in my scripts to overwrite a cube despite it being "locked"? There just has to be a way to deal with refreshing cube without everybody having to vacate it. Thanks!
Quote from: CW41 on 12 Jun 2015 12:19:23 AM
Hey everyone,
I have a script that executes cube builds every night. However, not all of my users like to exit the cube after viewing it through Cognos Connection, which would result in my script not updating the cube. Are there arguments I can use in my scripts to overwrite a cube despite it being "locked"? There just has to be a way to deal with refreshing cube without everybody having to vacate it. Thanks!
Hi,
Using Transformer's "Copy and activate" functionality would prevent this locking issue from happening. Take a look at the Transformer User Guide, Chapter 8 - "Updating Published PowerCubes and PowerCube Connections"
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_cogtr.pdf
Cheers!
MF.
Thanks, MFGF! I'll study up. It's been a minute since I've played around with the cube scripts.