[Mondrian] Dimension Property Member_Key not supported.

[Julian Hyde]

You are correct. Mondrian does not support the MEMBER_KEY property. I
guess it was added in SSAS 2005.
 
The MDX statement you give would definitely return the property, if we
supported it. Our validation around DIMENSION PROPERTIES is loose, so I
guess mondrian will not complain if you ask for it, just return nothing.
 
Please log a bug that MEMBER_KEY is not supported, and feel free to go
fix it.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Shishir Das
Sent: Tuesday, May 15, 2007 3:52 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Dimension Property Member_Key not supported.



Hi, 

We are facing an issue where Dimension Property MEMBER_KEY is queried
for but is not returned by mondrian. We found that mondrian did not have
any definition for this property.When we ran similar query against
Analysis services 2005 it returned 0 for allMembers and Member Name
otherwise. Is this logic of deriving value of MEMBER_KEY sufficient? 

example MDX:- 
WITH SET [Calc_Mem] AS
'CROSSJOIN(HIERARCHIZE(UNION({[Gender].[(All)].MEMBERS},
{[Gender].[Gender].MEMBERS}, ALL)), {[Measures].[Unit Sales]})' 
SELECT [Calc_Mem] DIMENSION PROPERTIES PARENT_LEVEL, MEMBER_KEY,
PARENT_UNIQUE_NAME ON AXIS(0) 
 FROM [Warehouse and Sales] CELL PROPERTIES VALUE, FORMAT_STRING,
LANGUAGE 

Regards, 
Shishir

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070515/5089f967/attachment.html