From C# I need to determine if a cube is currently processing. We are trying to avoid running MDX against a cube while in the act - it results in an error message to our users.
Does anybody know of a way to do this? Maybe with AMO?
Thanks in advance,
John
Hello John,
There is no easy way of doing this in AMO, but you could use the DISCOVER_LOCKS schema rowset to test whether there are write locks on your cube. The LOCK_STATUS and LOCK_TYPE fields returned by this discover could help you find this out.
Hope this helps,
Artur
No comments:
Post a Comment