[Mondrian] how to output of properties in a mdx-query

Julian Hyde julianhyde at speakeasy.net
Fri Jun 15 13:15:31 EDT 2007


> how can I output the content of the property in jpivot?

In the mondrian API, the properties are already there, attached to each
member.

The problem is the user interface. I don't think jpivot displays member
properties.

One workaround is to convert properties into calculated members and
display them as if they are measures.

With member [Measures].[Customer phone number] as
 ' [Customer].Properties("Phone number") '
Select 
 {[Measures].[Unit Sales],
  [Measures].[Customer phone number]} on columns,
 {[Customer].[Customer name].Members} on rows
>From [Sales]

Julian




More information about the Mondrian mailing list