Skip to Content
0
Former Member
Nov 19, 2008 at 12:29 PM

Locking the users

48 Views

Hi Friends,

Every 3 months we have submissions that need to go from BPS cube to BCS cube. So we run a process chain overnight to copy the planning data from 'WIP' version to current version in the Brands skeleton cubes and copy the same to BCS cube.

The problem here is some time it get failed over night and we want to run it at day time. Since we got 5 departmets(brands) using the BPS, if any user loged in to BPS and start to do plan, the BCS loads will fail with lock errors, because we are writting data from 'WIP' version to current version in the Brands skeleton cubes before copying to BCS.

The solution we need is we want to lock all the users not to do any plan until we give them access. Since we are writting data in all the Brands cubes we cant lock anyversions with data slices.

What we need is to keep the users not to enter in to BPS until the chain is finished.

Thanks in advance.

Sri