OLAP Cube Restrict Access to rows based on a user groups

[Criptic]

Hello,

I have a cube in which I need to restrict access on a row-level. The dimension / hierarchie / level are pictured in the image below:

Now what I already got: I can add the MDX statement to the dimension on the correct user group but the statment seems to be wrong and I hope that somebody here can help me:

For the group named 125 the statement looks like this:

{[Kunden_Dim].[Kunden_GS_DIM].[Alle Kunden_GS_DIM],[Kunden_Dim].[Kunden_GS_DIM].[Alle Kunden_GS_DIM].[ ],[Kunden_Dim].[Kunden_GS_DIM].[Alle Kunden_GS_DIM].[ ].[125],Descendants([Kunden_Dim].[Kunden_GS_DIM].[Alle Kunden_GS_DIM].[ ].[125])}

Thank you in advance for your time and wisdom

Kind Regards

Criptic

[AhmedAl_Attar]

Hi @Criptic

Check this SAS Global Forum (SGF) paper Enhancements for Managing SAS® OLAP Server in SAS® 9.2

Page 9 onwards of this paper, addresses the steps to setup MDX for Row-Level security.

Here is an additional paper Secure SAS® OLAP Cubes with Top Secret Permissions

Hope this helps,

Ahmed

[AhmedAl_Attar]

@Criptic

Here is another useful SGF paper touching on this topic 

 - How to Automate Security Filters for SAS® OLAP Cubes Using Users Groups Information Available in SAS...

Ahmed

[Criptic]

Thank you @AhmedAl_Attar I will check both of these out