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

[Roland Bouman]

I'm quite sure i've seen evidence of properties in the cellset being
returned via XML/A when there is a CELL PROPERTIES clause present in the
MDX.


On Wed, Jan 30, 2013 at 4:26 PM, Andy Grohe <agrohe21 at gmail.com> wrote:

> Not when typing in your own MDX using admin.  If you use properties in
> analyzer, they are not in the MDX.  It somehow is magical.
>
> Sent from my mobile device
>
> On Jan 30, 2013, at 8:43 AM, Matt Campbell <mcampbell at pentaho.com> wrote:
>
> In analyzer any attribute with properties shows up with a number to the
> right of it, e.g. Customers in Steel Wheels:****
>
> ** **
>
> <image002.png>****
>
> ** **
>
> 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<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> 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****
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>


-- 
Roland Bouman
blog: http://rpbouman.blogspot.com/
twitter: @rolandbouman
linkedin: http://www.linkedin.com/profile/view?id=5142800&trk=tab_pro

Author of "Pentaho Solutions" (Wiley, ISBN: 978-0-470-48432-6
http://tinyurl.com/lvxa88) and "Pentaho Kettle Solutions" (Wiley, ISBN:
978-0-470-63517-9 http://tinyurl.com/33r7a8m)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130130/37655078/attachment-0001.html