[Mondrian] Placing Member Properties of a level on same row as the member

Matt Campbell mcampbell at pentaho.com
Wed Jan 30 09:43:52 EST 2013

In analyzer any attribute with properties shows up with a number to the right of it, e.g. Customers in Steel Wheels:

[cid:image002.png at 01CDFECE.503E9850]

Those attributes have a right click option to be displayed on the crosstab.

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Andy Grohe
Sent: Wednesday, January 30, 2013 9:14 AM
To: mondrian
Subject: Re: [Mondrian] Placing Member Properties of a level on same row as the member

The properties don't show in the PSW query either, so it seems something else is going on here?
On Jan 30, 2013 7:46 AM, "Matt Campbell" <mcampbell at pentaho.com<mailto:mcampbell at pentaho.com>> wrote:
Use of the dimension properties clause tells Mondrian to include the requested properties in the results of the query, but it's still up to the client to do something with them.  Some MDX clients I've looked at make the properties available as a right click option on the dimension members in the crosstab.

Your last example includes the property in a measure which is explicitly included in the cellset.

From: mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org> [mailto:mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org>] On Behalf Of Andy Grohe
Sent: Tuesday, January 29, 2013 10:56 PM
To: mondrian
Subject: [Mondrian] Placing Member Properties of a level on same row as the member

Would love to know why this query does not return the Phone for each Customer?

select [Measures].AllMembers ON COLUMNS,
  [Customers].[Customer].Members DIMENSION PROPERTIES [Customers].Phone ON ROWS
from [SteelWheelsSales]

Nor does this....
select [Measures].AllMembers ON COLUMNS,
  {[Customers].[Customer].Members, [Customers].currentmember.properties("Phone")} ON ROWS
from [SteelWheelsSales]

but this does work...., but the member property is on the Measures axis not the axis where the Customers dim is located.....
with member Measures.Phone as '[Customers].currentmember.properties("Phone")'
select [Measures].AllMembers ON COLUMNS,
  [Customers].[Customer].Members ON ROWS
from [SteelWheelsSales]

Any insight is appreciated.

Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130130/277e3e6a/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 1907 bytes
Desc: image002.png
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20130130/277e3e6a/attachment.png 

More information about the Mondrian mailing list