[Mondrian] Add hour level to Time dimension

Julian Hyde jhyde at pentaho.com
Tue Jul 21 17:56:46 EDT 2009

By the way, I added level types Hours, Minutes, Seconds (also HalfTear and
Unspecified) in change 12749; I also added to the olap4j API. Will be in the
next mondrian release.
But I agree with the wizards on this thread: level types don't give you
much, and are no substitute for good schema design.


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Nicholas Goodman
Sent: Tuesday, July 21, 2009 9:53 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Add hour level to Time dimension

+1.  I've always split out time of day as well.

Really the only reason to use the special Mondrian time dimension
configuration is to be able to do "YTD()" and other special time MDX
functions.  I don't think there's any HTD() (hour to date) or other
shortcuts that would benefit you.  

Is there some reason, other than your performance requirement, that you'd
like it part of the same time dimension?

On Tue, Jul 21, 2009 at 5:52 AM, Pedro Alves <pmgalves at gmail.com> wrote:

Considering the performance , my solution is to separate the time
dimension(which i think is not good, cause I cant drill down through

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

More information about the Mondrian mailing list