Hi again,
I've been having some trouble implemente a Dynamic Security MDX
scenario.

I have a dimension [Red], that is a parent-child dimension. I've
created a member properties "Users" that contains the users separeted
by ";" (ex: ;u185733;v911868;u184785.

I've been trying the following MDX expression in the "Allowed Member"
box:

filter([Red].AllMembers,INSTR(1,[Red].CurrentMember.Properties("Users"),";"+
Mid(UserName,InStr(1,UserName,"\")+1) +";")>0)

As 'UserName' comes with the server name, i used
"Mid(UserName,InStr(1,UserName,"\")+1)" to separate the user (ex:
"BEST-DESTMRA\u185733" ---Mid(...)---> "u185733")

I get the following error: Error generated by the user - the dimension
"Red" does not contain any valid member. For more information....."


Emiliano D. Llera Do Campo
Telecom Argentina S.A.

I tried this and it worked:

filter([DimRed_vw].AllMembers,InStr(1,[DimRed_vw].CurrentMember.Properties("Users"),"u185733")>0)

,so i supose the error is in:

*** ";"*Mid(UserName,InStr(1,UserName,"\")+1) +";" ***

I'd really appreciate any help
Thanks :-)
Emiliano