[Mondrian] CurrentDateMember

Shaffner Joshua joshua.shaffner at goodwill.org
Wed Oct 1 18:16:50 EDT 2008


Per a couple suggestions in IRC as well as Julian¹s blog (
http://julianhyde.blogspot.com/2006/10/mondrian-22-cube-designer-and.html),
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.

SELECT NON EMPTY {[Measures].[Retail Store Sales], <truncated>} ON COLUMNS,

NON EMPTY 
{
CurrentDateMember([Time], '[\"Time\"]\\.[yyyy]\\.[MMM]').Lag(12) :
CurrentDateMember([Time], '[\"Time\"]\\.[yyyy]\\.[MMM]')
}
ON ROWS

from [MRSDS]
where [Organization].[All Organizations].[<truncated>]


PS: I have Time Hierarchy with two levels, year and month.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20081001/f5df7131/attachment.html 


More information about the Mondrian mailing list