<HTML>
<HEAD>
<TITLE>Re: [Mondrian] CurrentDateMember</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Finally got this working..<BR>
<BR>
Interesting that it works without [\&#8221;Time\&#8221;]?<BR>
<BR>
CurrentDateMember([Time], '[yyyy]\.[mmm]').Lag(12) :<BR>
CurrentDateMember([Time], '[yyyy]\.[mmm]')<BR>
<BR>
<BR>
On 10/1/08 6:16 PM, &quot;Joshua Shaffner&quot; &lt;<a href="joshua.shaffner@goodwill.org">joshua.shaffner@goodwill.org</a>&gt; 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&#8217;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], &lt;truncated&gt;} ON COLUMNS,<BR>
<BR>
NON EMPTY <BR>
{<BR>
CurrentDateMember([Time], '[\&quot;Time\&quot;]\\.[yyyy]\\.[MMM]').Lag(12) :<BR>
CurrentDateMember([Time], '[\&quot;Time\&quot;]\\.[yyyy]\\.[MMM]')<BR>
}<BR>
ON ROWS<BR>
<BR>
from [MRSDS]<BR>
where [Organization].[All Organizations].[&lt;truncated&gt;]<BR>
<BR>
<BR>
PS: I have Time Hierarchy with two levels, year and month.<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></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>
</BODY>
</HTML>