<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18813"></HEAD>
<BODY>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">Brian,</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">Thanks for stepping up. I've checked in the change, as change
12980. You can either build from source, or pull from Pentaho's nightly
build.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">I've tested Mondrian pretty thoroughly, so to reiterate, your
main task is to check that JPivot works. Use <FONT color=#000000 size=3
face="Times New Roman">mondrian.olap.SsasCompatibleNaming=false</FONT> (the
default value). I'm not so confident that JPivot will work with <FONT
color=#000000 size=3
face="Times New Roman">mondrian.olap.SsasCompatibleNaming=true</FONT>, and even
though we want that behavior to be the default in future, we don't need it to
work now.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">The thing to watch for is the naming of hierarchies. Consider
the Weekly hierarchy in the Time dimension. If SsasCompatibleNaming=false, this
will be named [Time.Weekly], but mondrian will also accept [Time].[Weekly], so
that is what JPivot should generate.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">If SsasCompatibleNaming=true, Mondrian will generate
[Time].[Weekly] as the dimension name. And more importantly, you cannot use the
dimension name as a shorthand for the dimension's default hierarchy. Where you
had previously written [Time].CurrentMember, you now need to write
[Time].[Time].CurrentMember. This is a bit of a pain, but you can see why it is
necessary if a dimension contains half a dozen hierarchies, and it is fully
consistent with SSAS2005. I know the transition to SsasCompatibleNaming=true as
default will be a pain. I intend to do that in 4.0.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">Once again, thanks for agreeing to do this. This feature will
allow us to create lots of hierarchies in the same dimension, and the
'attribute-oriented hierarchy' style should improve usability
significantly.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">We don't need this urgently, but if you can do it in the next
week, that would be good.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">Olap4j & PAT developers,</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">This is an important new feature in Mondrian that you should
be aware of.</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans">Julian</FONT></SPAN></DIV>
<DIV><SPAN class=302334720-02082009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV><FONT color=#000080 size=2
face="Lucida Sans"></FONT><FONT color=#000080 size=2
face="Lucida Sans"></FONT><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Brian Vandenberg
[mailto:phantall@gmail.com] <BR><B>Sent:</B> Friday, July 31, 2009 2:09
PM<BR><B>To:</B> jhyde@pentaho.com; Mondrian developer mailing
list<BR><B>Subject:</B> Re: [Mondrian] RE: Same hierarchy on different
axis<BR></FONT><BR></DIV>
<DIV></DIV> I can probably tinker with it early next week. Gimme
the details (what to download, semantics, etc) and I'll try it out on a schema
I'm building up.<BR><BR>-Brian<BR><BR>
<DIV class=gmail_quote>On Fri, Jul 31, 2009 at 2:47 PM, Julian Hyde <SPAN
dir=ltr><<A
href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV class=im><FONT color=#000080 size=2 face="Lucida Sans"></FONT><BR>>
At Thursday, July 23, 2009 6:57 PM Julian Hyde wrote:<BR>><BR>> I'm on
the point of checking in this fix.<BR>><BR>> However, I need someone
to verify that Jpivot works against<BR>> this change, and fix it if
necessary. Can someone volunteer<BR>> to do that? (You only need to check
with<BR>> mondrian.olap.SsasCompatibleNaming=false.)<BR><BR></DIV>This
change has been in the can, ready to check in, for over a week.<BR>However,
I don't have time to test & fix jpivot, and I cannot make a change<BR>to
mondrian if it is going to break jpivot. Can someone please take that
on?<BR>
<DIV>
<DIV></DIV>
<DIV
class=h5><BR>Julian<BR><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></DIV></DIV></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY></HTML>