In this post we'll learn how to create a drill down hierarchy for Days-->Hours-->Minutes-->Seconds. A general quick solution, in case you need the drill mostly for pivot table visualizations, would be to use the ElastiCube to model additional hour/minute/second columns - Add then create a hierarchy using those columns.
In the ElastiCube Manager, use the Add Custom Field to the table in the ElastiCube which holds your timestamp.
Create each field, make sure to set them to Type: Int, and in the editor - Use the GetHour(Date) / GetMinute(Date) / GetSecond(Date) to create each field accordingly (see example below).
Build your cube.
Example for syntax to create "Hour" custom column:
In the web browser, browse to http://localhost:8081 [or the port where Sisense is installed if other than the default].