[Mondrian] Reference Members By Key
Julian Hyde
jhyde at pentaho.com
Fri Jan 9 05:52:16 EST 2009
Somewhat. We don't support references to compound keys (e.g.
[Customer].[Zipcode].&[97117]&[34]).
And I don't think we support references that go direct to a leaf member,
such as your example [Product].&[1]. Maybe if you specifid the level it
would work better: [Product].[Product Name].&[1].
I see that our tests reference members such as [Warehouse].[State
Province].&[DF].[Mexico City].[Freeman And Co] and it seems to work...
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of michael.pflug at thomsonreuters.com
Sent: Thursday, January 08, 2009 7:16 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Reference Members By Key
Hi All,
In Mondrian should I be able to reference a member by key like I can in AS?
For example:
select
{[Product].&[1]} on 0 ,
{Measures.[Unit Sales]} on 1 from sales
returns 83.00 in MSAS but returns null in Mondrian through command runner.
Thanks,
Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090109/f4a444a2/attachment.html
More information about the Mondrian
mailing list