Dimension name is Testd

Levels are
level1
level2
level3
….
….

I need to make all levels available to the user, but default to level3
based on login user.

member property userid2 is available under Level3

tail(filter( [testd].[level3].members,[testd].currentmember.properties
("UsrId2")=USERNAME),1).item(0)

This does not seem to work unless I make Level3 the first level on the
front end tool. Is this a front end tool issue or is my MDX incorrect? The
MDX by itself does return the expected result in the MDX sample application

TIA

--
Message posted via http://www.sqlmonster.com