Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dealing with different timezones

  1. #1
    Join Date
    Aug 2008
    Posts
    563

    Default Dealing with different timezones

    Hi,
    In our raw data we store the time in UTC. For various client reports, we have to use the client specific timezone. Is there a way to implement this in a metadata model without having a complex lookup table?
    Best regards,
    Diethard
    ===============
    Visit my Pentaho blog which offers some tutorials mainly on Kettle, Report Designer and Mondrian
    ===============

  2. #2
    Join Date
    Mar 2008
    Posts
    364

    Default

    Hi!
    I had a similar problem and I solved it using the databse to translate the field.
    I wrote an oracle function utc_to_local() that i call when i want to retrieve the time in local zone. In the report I use an advanced datasource so that i can switch between the
    local and the utc field (from the metadatamodel).
    On the platform you can subclass the mql query generator and switch the field in there (maybe based on a user setting).

    If you found an easier solution please let me know.

    cheers,

    mgie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.