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

Andy Grohe agrohe21 at gmail.com
Wed Jan 30 18:43:55 EST 2013


Thanks.I will try the crossjoin idea.
On Jan 30, 2013 4:05 PM, "Matt Campbell" <mcampbell at pentaho.com> wrote:

> Andy-****
>
> With your 3rd query:****
>
> ** **
>
> with member Measures.Phone as
> '[Customers].currentmember.properties("Phone")'****
>
> select [Measures].AllMembers ON COLUMNS,****
>
>   [Customers].[Customer].Members ON ROWS****
>
> from [SteelWheelsSales]****
>
> ** **
>
> You said the problem with it was that it’s “on the Measures axis not the
> axis where the Customers dim is located”.  If you want both on the same
> axis you could crossjoin measures and customers.  It sounds like you really
> want the property values treated as dimension members so they can be
> included in a set in the same way Customer members are.  I’m not aware of a
> way to do that, apart from changing your schema to add new hierarchies for
> these props.****
>
> ** **
>
> BTW, the other query you had has a couple problems with it.****
>
> ** **
>
> select [Measures].AllMembers ON COLUMNS,****
>
>   {[Customers].[Customer].Members,
> [Customers].currentmember.properties("Phone")} ON ROWS****
>
> from [SteelWheelsSales]****
>
> ** **
>
> The .CurrentMember function is not acting on each member of the [Customer]
> level—it’s acting on the default member of the [Customers] dimension
> (likely [All] in this case).  Generate() could be used, BUT… second
> problem—a set consists of a collection of tuples.  The .Properties()
> function returns a value, not a member, so cannot be included in a set in
> this way.****
>
> ** **
>
> Matt****
>
> ** **
>
> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> *On Behalf Of *Paul Stoellberger
> *Sent:* Wednesday, January 30, 2013 11:01 AM
> *To:* Mondrian developer mailing list
> *Subject:* Re: [Mondrian] Placing Member Properties of a level on same
> row as the member****
>
> ** **
>
> CELL PROPERTIES aren't DIMENSION PROPERTIES****
>
> ** **
>
> its two different kind of mdx****
>
> ** **
>
> CELL PROPERTIES affect any additional properties for cells (usually
> formatting options such as "FONT_COLOR" , …)****
>
> In jpivot, analyzer saiku we fake those by using a specific FORMAT_STRING
> ****
>
> ** **
>
> DIMENSION PROPERTIES include level properties etc.****
>
> ** **
>
> -Paul****
>
> ** **
>
> On Jan 30, 2013, at 4:51 PM, Roland Bouman <roland.bouman at gmail.com>
> wrote:****
>
>
>
> ****
>
> 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) ****
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130130/dc0cef8f/attachment-0001.html 


More information about the Mondrian mailing list