Hi all,



I´d like to make a dinamic dimension security using a dimension
property... for example, I wanna see only Versions with property = "P",
then I thought something like this on Allowed Members permission:



[Version].currentMember.properties("TYPE") = "P"



Ok, but I can´t use this mdx expression there, do you know if I
can do it?!



Being clear: I have 3 members on a Flat Dimension:



VERSION1 property type = "X"

VERSION2 property type = "X"

VERSION3 property type = "P"



I should see only the VERSION3 in which contains a P value property.



Thanks,

Alex Berenguer


--
Posted via http://dbforums.com

Hi Chris!!!



I´m including the filter on Allowed Members permission, but using the
Filter, it worked as expected.



THe unique change on your expression was to "[Store].members" because
it´s a flat dimension.



Thanks in advance,



Alex Berenguer


--
Posted via http://dbforums.com