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

[Roland Bouman]

Paul, Andy,

Not sure if we're talking about the same thing, but XML/A returns dimension
properties as well.
For instance, a query like:

SELECT {[Measures].[Quantity]} ON Axis(0)
,      {[Customers].[Customer].Members} DIMENSION PROPERTIES
[Customers].[Customer].[Phone] ON Axis(1)
FROM   [SteelWheelsSales]

will return tuples like this:

<Tuple>
<Member Hierarchy="Customers">
<UName>[Customers].[Volvo Model Replicas, Co]</UName>
<Caption>Volvo Model Replicas, Co</Caption>
<LName>[Customers].[Customer]</LName>
<LNum>1</LNum>
<DisplayInfo>131072</DisplayInfo>
<Phone>0921-12 3555</Phone>
</Member>
</Tuple>


On Wed, Jan 30, 2013 at 5:01 PM, Paul Stoellberger <p.stoellberger at gmail.com
> wrote:

> 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
>
>


-- 
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/20130131/41474bf9/attachment-0001.html