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

Andy Grohe agrohe21 at gmail.com
Tue Jan 29 22:55:36 EST 2013


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130129/46d2696f/attachment.html 


More information about the Mondrian mailing list