Analysis Services Dynamic Security

Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted to see specific data. This can be accomplished by creating dynamic or table based security in Analysis Services which is much less difficult to setup than it sounds like. In this article I will walk you through the setup needed on the relational database side as well as Analysis Services side to get this working in your environment.