[Mondrian] timezones in timedimension

Oren Mazor oren.mazor at shopify.com
Wed Mar 20 12:03:31 EDT 2013


Hey all,

so, all of my data is imported as UTC and stored as UTC (both facts and
dimensions). but I want to be able to query with respect to a timezone…

I have some thoughts on how to do this, namely de-timezone my timedimension
and assume that when facts point at a time member, that time member is in
the native timezone. I'm not a fan, as that will make my ETL much less
pleasnat than it could be.

is there any way to do this in mdx?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130320/ac5f934c/attachment.html 


More information about the Mondrian mailing list