[Mondrian] Add hour level to Time dimension

Lin Chun franks1984 at gmail.com
Tue Jul 21 08:45:53 EDT 2009


In my projet, the granularity of time dimension is Hour, but seems Mondrian
schema doesn’t support hour level.
Considering the performance , my solution is to separate the time
dimension(which i think is not good, cause I cant drill down through day), I
create Date table(year, month,day..)  and Time table (am, hour..), as same,
I create two dimensions in Mondrian schema, one use timeDimension type,
other use regular type.

Any suggestion will be grateful,


Lin Chun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090721/79d239f6/attachment.html 

More information about the Mondrian mailing list