Using Standard Access Mode

When you open an OLAP model in standard access mode, Integration Services gives you a read lock on that OLAP model. When you open a metaoutline in standard access mode, Integration Services gives you a read lock on that metaoutline and a read lock on the OLAP model on which the metaoutline is based. Multiple users can have read locks on the same OLAP model or metaoutline at the same time.

When you save an OLAP model or metaoutline in standard access mode, Integration Services upgrades the read lock to a write lock for the duration of the save. After Integration Services saves the changes to the OLAP model or metaoutline, the lock reverts back to a read lock. However, if other users have the OLAP model or metaoutline open, your changes are not updated for the other users until they reopen the document.

In addition, if other users have the OLAP model or metaoutline open at the same time as you do, they can edit and save it, thereby overwriting your changes. Using exclusive access mode prevents users from overwriting your changes. See Using Exclusive Access Mode.

  If you opened and edited an OLAP model or metaoutline in standard access mode, and are concerned that other users may overwrite your changes, perform one of the following actions:

  • Save the OLAP model or metaoutline using a different name. See Integration Services Console Help.

  • If you have not yet started editing the document or have entered only a few changes, close the OLAP model or metaoutline and then reopen it using exclusive access mode and reapply the changes.

  • Contact the users with read locks and ask them to close the OLAP model or metaoutline. To view a list of users with read locks, see Viewing Integration Services Users with Locks.