AnsweredAssumed Answered

Rolling Up Time Stamps into Hours

Question asked by fordreid on Oct 18, 2018
Latest reply on Oct 19, 2018 by fordreid

Greetings!

 

My problem is this, I need to be able to track the number of records being entered into our system by Day and Hours. 

 

I currently am loading a cube from SQL that contains a Date/Time Stamp field.  I am cubing off the Date by Day but need a way to delimit the Time Stamp and find a way to roll up these times into groups by hour. 

 

Is this something that I can do within an Data Reader ETL protocol?  Or is there Nexel function that can calculate the hour?

 

Any help with this is greatly appreciated.

 

Thanks!

Ford

Outcomes