<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">CELL PROPERTIES aren't DIMENSION PROPERTIES<div><br></div><div>its two different kind of mdx</div><div><br></div><div>CELL PROPERTIES affect any additional properties for cells (usually formatting options such as "FONT_COLOR" , …)</div><div>In jpivot, analyzer saiku we fake those by using a specific FORMAT_STRING </div><div><br></div><div>DIMENSION PROPERTIES include level properties etc.</div><div><br></div><div>-Paul</div><div><br></div><div><div><div>On Jan 30, 2013, at 4:51 PM, Roland Bouman <<a href="mailto:roland.bouman@gmail.com">roland.bouman@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">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. </div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Wed, Jan 30, 2013 at 4:26 PM, Andy Grohe <span dir="ltr"><<a href="mailto:agrohe21@gmail.com" target="_blank">agrohe21@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="auto"><div>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.<br><br>Sent from my mobile device</div><div class="im"><br>On Jan 30, 2013, at 8:43 AM, Matt Campbell <<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>> wrote:<br>
<br></div><blockquote type="cite"><div class="im"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">In analyzer any attribute with properties shows up with a number to the right of it, e.g. Customers in Steel Wheels:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p></div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><image002.png></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<div><div class="h5"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Those attributes have a right click option to be displayed on the crosstab.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a> [<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mailto:mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Andy Grohe<br>
<b>Sent:</b> Wednesday, January 30, 2013 9:14 AM<br><b>To:</b> mondrian<br><b>Subject:</b> Re: [Mondrian] Placing Member Properties of a level on same row as the member<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p><p>The properties don't show in the PSW query either, so it seems something else is going on here?<u></u><u></u></p><div><p class="MsoNormal">On Jan 30, 2013 7:46 AM, "Matt Campbell" <<a href="mailto:mcampbell@pentaho.com" target="_blank">mcampbell@pentaho.com</a>> wrote:<u></u><u></u></p>
<div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Your last example includes the property in a measure which is explicitly included in the cellset.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Andy Grohe<br>
<b>Sent:</b> Tuesday, January 29, 2013 10:56 PM<br><b>To:</b> mondrian<br><b>Subject:</b> [Mondrian] Placing Member Properties of a level on same row as the member</span><u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">Would love to know why this query does not return the Phone for each Customer?<u></u><u></u></p><div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">select [Measures].AllMembers ON COLUMNS,<u></u><u></u></p>
</div><div><p class="MsoNormal"> [Customers].[Customer].Members DIMENSION PROPERTIES [Customers].Phone ON ROWS<u></u><u></u></p></div><div><p class="MsoNormal">from [SteelWheelsSales]<u></u><u></u></p></div></div><div><p class="MsoNormal">
<u></u><u></u></p></div><div><p class="MsoNormal">Nor does this....<u></u><u></u></p></div><div><div><p class="MsoNormal">select [Measures].AllMembers ON COLUMNS,<u></u><u></u></p></div><div><p class="MsoNormal"> {[Customers].[Customer].Members, [Customers].currentmember.properties("Phone")} ON ROWS<u></u><u></u></p>
</div><div><p class="MsoNormal">from [SteelWheelsSales]<u></u><u></u></p></div></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">but this does work...., but the member property is on the Measures axis not the axis where the Customers dim is located.....<u></u><u></u></p>
</div><div><div><p class="MsoNormal">with member Measures.Phone as '[Customers].currentmember.properties("Phone")'<u></u><u></u></p></div><div><p class="MsoNormal">select [Measures].AllMembers ON COLUMNS,<u></u><u></u></p>
</div><div><p class="MsoNormal"> [Customers].[Customer].Members ON ROWS<u></u><u></u></p></div><div><p class="MsoNormal">from [SteelWheelsSales]<u></u><u></u></p></div></div><div><p class="MsoNormal"> <u></u><u></u></p></div>
<div><p class="MsoNormal">Any insight is appreciated.<u></u><u></u></p></div></div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><u></u><u></u></p></div></div></div></blockquote><div><div class="h5"><blockquote type="cite">
<div><span>_______________________________________________</span><br><span>Mondrian mailing list</span><br><span><a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a></span><br><span><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a></span><br>
</div></blockquote></div></div></div><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Roland Bouman<br>blog: <a href="http://rpbouman.blogspot.com/" target="_blank">http://rpbouman.blogspot.com/</a><br>twitter: @rolandbouman<br>linkedin: <a href="http://www.linkedin.com/profile/view?id=5142800&trk=tab_pro" target="_blank">http://www.linkedin.com/profile/view?id=5142800&trk=tab_pro</a><br>
<br>Author of "Pentaho Solutions" (Wiley, ISBN: 978-0-470-48432-6 <a href="http://tinyurl.com/lvxa88" target="_blank">http://tinyurl.com/lvxa88</a>) and "Pentaho Kettle Solutions" (Wiley, ISBN: 978-0-470-63517-9 <a href="http://tinyurl.com/33r7a8m" target="_blank">http://tinyurl.com/33r7a8m</a>)
</div>
_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>http://lists.pentaho.org/mailman/listinfo/mondrian<br></blockquote></div><br></div></body></html>