Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Out of the box time dimension table?

  1. #1
    Join Date
    Apr 2013
    Posts
    19

    Default Out of the box time dimension table?

    I'm trying to create a time dimension table on my db to connect to my fact table with several time metrics. However, using my date field in the data and several date_format() syntax to convert the time stamp I'm finding that I am missing certain hours in the day.

    Is there an out of the box transformation for PDI for time dimensions?

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    You can try "Select values" if you want to change the date format.

    Mick

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.