<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [Mondrian] CurrentDateMember</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18099" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2>Thanks for the kind words, Tim.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2>I wasn't aware of the <A
href="http://liris.cnrs.fr/~sbimonte/view.pdf"><FONT face="Times New Roman"
size=3>http://liris.cnrs.fr/~sbimonte/view.pdf</FONT></A> presentation. Thanks
for mentioning it. It's a little out of date (2006), but it has a fair amount of
depth, and I recommend it to anyone wanting a crash-course in mondrian's
architecture.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2>By the way I just checked in a fix for the "MMM" bug.
Change 11647, will be in mondrian-3.1.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=583455117-02102008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Timothy Jones
[mailto:Timothy.Jones@syniverse.com] <BR><B>Sent:</B> Thursday, October 02,
2008 5:48 AM<BR><B>To:</B> jhyde@pentaho.com; Mondrian developer mailing
list<BR><B>Subject:</B> RE: [Mondrian] CurrentDateMember<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff>Hi, Julian... </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff>I just subscribed to this list, hoping to catch these kinds of
great tips. I didn't expect them so fast though! GREAT
WORK!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff>My history with OLAP so far is that I got the JPivot/Mondrian
example at <A
href="http://liris.cnrs.fr/~sbimonte/view.pdf">http://liris.cnrs.fr/~sbimonte/view.pdf</A> working
under Eclipse/Tomcat, and I started adding new Mondrian schemas and new
databases within this app (2 so far, with probably 10-12 more on the
horizon). I can't say there were no struggles, because there were
multiple new-things-to-learn, but I was able to quickly prove that these two
tools can accomplish what I needed, and now my app continues to
grow. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff>My heartfelt thanks to everyone who has given of themselves to
create a fantastic product that <STRONG><EM>lets me impress my new
boss</EM></STRONG> (with relative ease). I hope to be able to contribute
back someday soon!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=140540712-02102008><FONT face="Avenir 55"
color=#0000ff>tlj</FONT></SPAN></DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Julian
Hyde<BR><B>Sent:</B> Wednesday, October 01, 2008 7:53 PM<BR><B>To:</B>
'Mondrian developer mailing list'<BR><B>Subject:</B> RE: [Mondrian]
CurrentDateMember<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2>I think the example had extra '\'s because it was taken
from Java code (inside java strings, " and \ need to be escaped). That's why
it worked for you to change '\\.' to '\.'.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2>If you had changed '\"Time\"' to '"Time"' it would
probably have worked too. It worked without Time because dimension names
are optional - although I recommend using dimension names, because it makes
your code clearer and reduces the amount of searching mondrian has to
do.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2>I also see that you changed MMM to mmm. I'm guessing that
in your dimension months look like 'jan' rather than
'JAN'.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2>Thanks for letting us know what
works.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=874494523-01102008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Shaffner
Joshua<BR><B>Sent:</B> Wednesday, October 01, 2008 3:29 PM<BR><B>To:</B>
Mondrian developer mailing list<BR><B>Subject:</B> Re: [Mondrian]
CurrentDateMember<BR></FONT><BR></DIV>
<DIV></DIV><FONT face="Calibri, Verdana, Helvetica, Arial"><SPAN
style="FONT-SIZE: 11pt">Finally got this working..<BR><BR>Interesting that
it works without [\”Time\”]?<BR><BR>CurrentDateMember([Time],
'[yyyy]\.[mmm]').Lag(12) :<BR>CurrentDateMember([Time],
'[yyyy]\.[mmm]')<BR><BR><BR>On 10/1/08 6:16 PM, "Joshua Shaffner" <<A
href="joshua.shaffner@goodwill.org">joshua.shaffner@goodwill.org</A>>
wrote:<BR><BR></SPAN></FONT>
<BLOCKQUOTE><FONT face="Calibri, Verdana, Helvetica, Arial"><SPAN
style="FONT-SIZE: 11pt">Per a couple suggestions in IRC as well as
Julian’s blog ( <A
href="http://julianhyde.blogspot.com/2006/10/mondrian-22-cube-designer-and.html">http://julianhyde.blogspot.com/2006/10/mondrian-22-cube-designer-and.html</A>),
I tried the query below but to no luck. I either get no results or
internal error. If you see something, let me know. I am stumped...after
trying this and that for a couple hours over just a couple of
lines.<BR><BR>SELECT NON EMPTY {[Measures].[Retail Store Sales],
<truncated>} ON COLUMNS,<BR><BR>NON EMPTY
<BR>{<BR>CurrentDateMember([Time], '[\"Time\"]\\.[yyyy]\\.[MMM]').Lag(12)
:<BR>CurrentDateMember([Time], '[\"Time\"]\\.[yyyy]\\.[MMM]')<BR>}<BR>ON
ROWS<BR><BR>from [MRSDS]<BR>where [Organization].[All
Organizations].[<truncated>]<BR><BR><BR>PS: I have Time Hierarchy
with two levels, year and month.<BR><BR>
<HR align=center width="95%" SIZE=3>
</SPAN></FONT><FONT size=2><FONT
face="Consolas, Courier New, Courier"><SPAN
style="FONT-SIZE: 10pt">_______________________________________________<BR>Mondrian
mailing list<BR><A
href="Mondrian@pentaho.org">Mondrian@pentaho.org</A><BR><A
href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR></SPAN></FONT></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>