Author Topic: Time Dimension  (Read 3814 times)

Offline cognostechie

  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 1,652
  • Forum Citizenship: +133/-7
    • Pervisol
Time Dimension
« on: 19 Jan 2016 12:31:42 pm »
Not sure where to post this so posting it here as Data Manager is closer to ETL design than BI tools.

I am wondering of anybody had implemented a Time Dimension (not a Date Dimension) and if so, willing to share the structure of the Dimension and Fact table? What's the granularity? Records by the hour, minute or second? Can you provide an example?
Ex: I want to track orders received in every 2 hr interval and have to compare that to the same time of yesterday.