A colleague had a problem concerning a query using the (NOT) IN predicate, use the following table creation script (attached to the blog entry) to see the effects of the problem and to repro it on your machine. Imagine you have two tables (not that hard till here) and you want to get the info...

Sometime you might be stuck in a situation for Analysis Services where you have to pull of security information from an external system to get the information about dimension or cell security. Implementing that is not that hard as you might think of. Though there are some things to keep in mind rega...