topic Re: OLAP Cube Restrict Access to rows based on a user groups in Administration and Deployment

OLAP Cube Restrict Access to rows based on a user groups

Criptic — Thu, 24 May 2018 11:49:55 GMT

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