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

Andy Grohe agrohe21 at gmail.com
Wed Jan 30 08:55:48 EST 2013


Well it seems that neither Jpivot, Analyzer MDX, OLAP Input, nor PRD do
anything with properties.
On Jan 30, 2013 7:46 AM, "Matt Campbell" <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]
> *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
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130130/8b4769b2/attachment.html 


More information about the Mondrian mailing list