Resolutions for common Issues and Facts while using SSAS 2005
In general these are some common that we must be aware of while working on SSAS else we end up wasting our precious time googling and reading articles in detail.
1. Locking mechanisms are inherent in Sql server 2005 (OLAPLockTypes). Hence this feature is deprecated.
* By default if a user is trying to update or process the objects in SSAS 2005. Other user will not be able to access that object until it becomes free.
* Explicit Rollback and Commit transactions provided by the server can help in granting both of the users or neither of them in updating or reading the cube simultaneously
Tags: performance