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:
![image.png image.png](/t5/image/serverpage/image-id/20744i4130F0C27ED3C5BC/image-size/medium?v=v2&px=400)
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