time dimension on semantic layer

[Former Member]

Hi All,

I have a field in my table which has got both date and time.  I want to create a time dimension just shows only time.  Is there anyway we can achieve this my some kind of format for the field where it can shows me just time only.

[Former Member · Accepted solution]

which database you are using in backend?

[Former Member · Accepted solution]

MSSQL 2014

[Former Member · Accepted solution]

You can try following syntax:

CONVERT(VARCHAR(12),datetime,114) 'hh:mi:ss:mmm'

Just create new object on universe

Time = CONVERT(VARCHAR(12),datetime,114) 'hh:mi:ss:mmm'

where datetime = object which contains date & time.

Thanks,
Swapnil