Report Portal

Securing a Dimension with Members Having the Same Name

Here's an SSAS security issue that doesn't come up very much at all. In fact, when this recently came up, I had forgotten about a solution I provided way back in 2005 (which was the only other time I've encountered this). The problem is that when securing an attribute member (a role's Dimension Data tab) using the member's name and not key (using the "Allowed Member Set" text box of the "Advanced" tab), and there is more than one member with that same name, only the first one will be secured.

Read more...

Tags: design, security

 

2007-2015 VidasSoft Systems Inc.