What type of MDX expression can I get away with in the Top
Level, Bottom Level, Allowed Members, and Denied Members
properties for a custom dimension security setup? I would
think that the MDX for Top Level and Bottom Level should
simply return level objects. And the MDX for Allowed
Members and Denied Members should return a set. But for
some MDX expressions I am trying in the Top Level
property, I get an error. The error message indicates
that the dialog box is attempting to validate the level
resulting from the MDX expression by adding a .Name
function to it. Unfortunately, the .Name function can't
be applied to every MDX function that returns a level (or
I'm writing my MDX expression wrong). Basically, I want
to return one of several levels based on conditions. So,
the MDX I am using is a big iif() statement. Will this
work?

Thanks,
Dave Fackler

This is precisely correct

This can be done, and I have done it in the past. Can you paste your MDX
expression and we can check where the problem is.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================