There is something that I need a basic explanation on concerning the use of the DeniedSet Property to restrict access to cube data. According to Books Online explanation
“The DeniedSet property uses an MDX expression to determine the attribute members to which a database role is explicitly denied access (the denied set)” (http://msdn.microsoft.com/en-us/library/ms175366.aspx).
In addition, once the denied set is specified, Books Online mention that
“The denied set that is specified for the
… attribute does not limit the visibility of newly added members … through the EXISTS key word” (http://msdn.microsoft.com/en-us/library/ms175586.aspx).
It is the second quote that I need clarification on using basic terms to explain it. Please consider the following MDX expression which is working well to address my need but I wonder what will happen if new data is loaded as we do data loads on a monthly
basis. We haven’t added new data yet since I created this expression.
View Complete Post