<HTML>
<HEAD>
<TITLE>CurrentDateMember</TITLE>
</HEAD>
<BODY>
<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>
</SPAN></FONT>
</BODY>
</HTML>