Hello,



I´m using scripting to create a simple Role with Dimension Security and
I have never got problem until I try to use the expression below on
AlowedSet:



dsoRole.SetPermissions "Dimension:Versao", "<MEMBERSECURITY
VisualTotalsLowestLevel=""[Versao].[Versao]""><PERMISSION
Access=""Read"" " AllowedSet=""Filter([Versao].members,
[Versao].currentMember.properties(""MEM_TYPE"") =
""P"")""/></MEMBERSECURITY>"



The message error is: -2147221436 Invalid member security
permission attribute: EM_TYPE") (Look, just EM_TYPE not MEM_TYPE
the first char is cut)



I can create this role using Analysis Manager without any problem using
the same expression above and it´s working.



The string looks like correct... including the quotation marks
correctly...



The property MEM_TYPE exists and it´s working perfectly when the role is
done through Analysis Manager.



Has Anyone any idea why it´s happening?!?!?!?!



Thanks in advance,



Alex Berenguer


--
Posted via http://dbforums.com

Thank you for your help Dave, but are you saying to put something like
Chr(34) instead of ""? Do you know how I could encode it?



Thank you for your continuous help,


--
Posted via http://dbforums.com

Hi Dave, I really didn´t get what you´ve said. To be honest with you I
really didn´t understand what you want to say when looking for "What
I'm saying is to use double-quotes only for delimiters in the VB code.".
Anyway, if you can make an example to me, I apreciate a lot.



Again, I need to force setPermissions to use the string sintax as
follow:



Filter([Versao].members,
[Versao].currentMember.properties("MEM_TYPE") = "P")



Has anybody any idea about it? I really need it a lot.



Best Regards and Thank you,



"...and let´s keep a nice day."

Alex Berenguer







Originally posted by Dave Wickert




--
Posted via http://dbforums.com

Hey guys, I got it writting &quot; intead of "".



Thank you all,

"...and tomorrow will be better than today."

Alex Berenguer

Brazil


--
Posted via http://dbforums.com