PDA

View Full Version : [Mondrian] RE: Looking up members by key



Julian Hyde
05-29-2007, 02:00 PM
Javier wrote:

> I have one question that might need to be solved in order to complete
our ad-hoc security.
> Is there any way to get a member of any level using the internal code
instead of the name?

> For example instead of using [Month].[February], [Month].[M2]...?

>

Julian wrote:

MDX supports the syntax '[Time].[1997].&[4]' where the '&' means get the
member with the key 4 rather than the name 4.



This is partly supported in mondrian. Try it - it might work.




We already tried it (because we saw it in the forums) and it didn