AnsweredAssumed Answered

Rolling Up Time Stamps into Hours

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



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.