Rolling Up Time Stamps into Hours

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

Find more posts tagged with

Usage

Accepted answers

All comments

Björn Reuber

Hi,

did you had a look on our changes to log files? Maybe the DataEntry.Log https://community.board.com/docs/DOC-1109-board-engine-logs-in-detail#jive_content_id_33_Dataentry_Log ; will help you with your request

Daniele Di Lorenzo

Hello

I have an applicatio that can inspire you:

I need to calculate the connection time between login-logouts

I load a string with datehour into a date cube, see my picture. It's correctly stored into the cube

Then through a layout I calculate the connection time. see the BQuery below

hope this helps

Show "Aux Login Events"
Show "Aux Logout Events"
Show "if(or(b=0,a=0),0,b-a)" Heading "Time Days"; dec 3; ShowZeros
Show "if(c<0,0,c*24)" Heading "Time Hours"; dec 2

Previous Member

Thank you Daniele Di Lorenzo!

I actually found a similar solution through a similar ETL function as you can see in my screen shot below:

BOARD ETL Hour Function

This allowed me to convert any time stamp into the military time hour of the day:

Thank you for the help!

Ford Reid