Claus on Code

A data dudes random musings about code, bugs, products, life etc.

  • SSAS Tip -> Format seconds as HHHH:MM:SS

    A common way of showing durations in SSAS, is to format them as HH:MM:SS. A common scenario is to store the durations in seconds. To display them in the HH:MM:SS format, first we have to convert the duration to hours, and then put on the format, like so CREATE MEMBER CURRENTCUBE.[MEASURES].[someMeasure] AS [Measures].[someMesureInSeconds]/86400,FORMAT_STRING = “HH:MM:SS”,… However,… Continue reading