PDA

View Full Version : [Mondrian] Dimension Property Member_Key not supported.



Shishir Das
05-15-2007, 07:11 AM
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
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Julian Hyde
05-15-2007, 12:22 PM
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 (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Shishir Das
Sent: Tuesday, May 15, 2007 3:52 AM
To: mondrian (AT) pentaho (DOT) 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


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian