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

Matt Campbell mcampbell at pentaho.com
Wed Jan 30 17:04:58 EST 2013


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<mailto: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<mailto: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<mailto: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> [mailto: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<mailto: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> [mailto: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<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian
_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto: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<mailto: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/84466f5b/attachment.html 


More information about the Mondrian mailing list