<!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=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></BODY></HTML>