Architecting, installing and maintaining your SAS environment

OLAP Cube Restrict Access to rows based on a user groups

Reply
Frequent Contributor
Posts: 86

OLAP Cube Restrict Access to rows based on a user groups

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

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

Super Contributor
Posts: 278

Re: OLAP Cube Restrict Access to rows based on a user groups

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

Super Contributor
Posts: 278

Re: OLAP Cube Restrict Access to rows based on a user groups

Frequent Contributor
Posts: 86

Re: OLAP Cube Restrict Access to rows based on a user groups

Posted in reply to AhmedAl_Attar

Thank you @AhmedAl_Attar I will check both of these out

Ask a Question
Discussion stats
  • 3 replies
  • 146 views
  • 4 likes
  • 2 in conversation