Dimension Data Security and Cube Script
User Rating: / 1
Written by Teo Lachev   
Tuesday, 31 May 2011 18:07

If you have worked with Analysis Services dimension data security for a while, you know that MDX allowed/denied set expressions can become rather complex. You might be tempted to externalize these expressions in the cube script for brevity or reusability reasons. For example, you might decide to add a calculated member that returns a list of allowed partners that the user is authorized to see over a factless fact table as follows:




XL Cubed