COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: wyconian on 27 Mar 2012 08:32:20 AM

Title: Cube Locking
Post by: wyconian on 27 Mar 2012 08:32:20 AM
Hi guys

I've been using Transformer 10.1.1 for the first time in a long while. When I make a change to a cube and run it through and then realise the change hasn't quite worked I have to wait for arund 20 minutes for the cube to unlock before I can run it again.  Anyone know how I can stop transformer from doing this or to at least reduce the amount of time it's locked?

(I know I should plan the cube more carefully so I don't have to do this but I'm very rusty lol)

Thanks for any help
Title: Re: Cube Locking
Post by: RobsWalker68 on 27 Mar 2012 08:53:59 AM
Hi,

The best thing to do is use the inbuilt deployment facility.  In Transformer have a look at the deployment tab in your Powercubes properties.  In essence you will build to one location and then, on completion of the build, this will be transferred to a deployment location. 

Your reporting/analysis tools should be pointed at the cube in the deployment location as this maintains a versioning and therefore allows you to rebuild a cube without the locking issues.

Rgds

Rob
Title: Re: Cube Locking
Post by: wyconian on 27 Mar 2012 10:46:54 AM
Thanks Rob I'll give it a try  :)