SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups, Audit enhancements, and User-Defined Server Roles. Default Schema for Windows Groups A database schema can now be tied to a … Continue reading →
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and the cube processes successfully. But when you try to connect to the cube, you get the following error message: The ‘XXX’ attribute in … Continue reading →
When using role security in SSAS, one point of confusion is when a person sees the grand total for a measure that includes the total of ALL members in the cube, even though the security has limited the members that person can … Continue reading →