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.