- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Here is another useful SGF paper touching on this topic
Ahmed
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @AhmedAl_Attar I will check both of these out