[Mondrian] CurrentDateMember
Shaffner Joshua
joshua.shaffner at goodwill.org
Wed Oct 1 18:29:24 EDT 2008
Finally got this working..
Interesting that it works without [\²Time\²]?
CurrentDateMember([Time], '[yyyy]\.[mmm]').Lag(12) :
CurrentDateMember([Time], '[yyyy]\.[mmm]')
On 10/1/08 6:16 PM, "Joshua Shaffner" <joshua.shaffner at goodwill.org> wrote:
> 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.
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20081001/49757d9b/attachment.html
More information about the Mondrian
mailing list