TR0787 Batch job question

[CW41]

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!

[MFGF]

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.

[CW41]

Thanks, MFGF! I'll study up. It's been a minute since I've played around with the cube scripts.