From Azaz on Analysis Services

PingBack from http://www.easycoded.com/dynamic-security-in-ssas-cube

Azaz Rasool:

Nice post on SSAS dynamic security. Trying to implement based on your post and got struck with following error. Appreciate you help.

MDX Query:

----------

EXISTS ( [Dim Account] . [Dim Account]. Members,

STRTOSET ( " [Dim Employee] . [LoginID] . [" + Username + "]"),

'Fact Secure Account'

)

-------------------------------

Getting errors:

Check MDX script syntax failed because of the following error:

----------------------------------

An error occurred in the MDX script for the dimension attribute permission's allowed member set: The dimension '[Dim Employee]' was not found in the cube when the string, [Dim Employee].[LoginID].[CORP\Name], was parsed.

-----------------------------------

Appreciate your help.

I'm having some trouble with the Username function.  If I use:

EXISTS([Dim Account].[Dim Account].Members,STRTOSET("[Dim Employee].[LoginID].[domain/user]"),'Fact Secure Account')

it works fine, but if I use the Username function then it doesn't.  I thought maybe it was the format that Username function returned so I check it via:

WITH MEMBER Measures.x AS UserName

SELECT Measures.x ON COLUMNS

FROM [Item In]

The domain/user string from my dimension and the Username function are identical.  Do you have any suggestions?

Thanks,

Jamin

Hi Azaz,

I am encountering the following error after following your suggested approach:

Check MDX script syntax failed because of the following error:

----------------------------------

An error occurred in the MDX script for the dimension attribute permission's allowed member set: The dimension '[Dim Employee]' was not found in the cube when the string, [Dim Employee].[LoginID].[CORP\Name], was parsed.

Can you please help me with this?

Hello All,

I got the resolution for my problem.

I was trying to implement custom security on database dimension instead of cube dimension. So, when I tried the same thing on cube dimensions, it worked perfectly.

Thanks for this great article.