Published on Thursday, April 2, 2015

Time Span Formatting in SSAS

Support for custom formatting string: DD.HH:MM:SS

ESS offers a BI Solution based on a SSAS Cube using the 3CX phone data.  One of the challenges in the cube implementation is the display of time span values in SSAS. The available “Format_string” options are limited and do not allow extensions.  The call data from the 3CX phone system is recorded in seconds. Some of the measures, such a  “Ringing Duration” and “Talking Duration”, require custom formatting when displayed on the client. The preferred format is the Time Span: “Days.Hours:Minutes:Seconds” or “DD.HH:MM:SS”.  This makes it very easy for the end user to comprehend the duration times compared to seeing a really big number, representing seconds (i.e. 4.11:03:13 vs. 9,834,132 sec). 

The BI Portal offers custom value formatting, which makes support for Time Spans easy.  Here is a snapshot of the 3CX cube data, displaying Talking Durations as well as common Time Calculations, automatically done in the cube:


Rate this article:
No rating
Comments (0)Number of views (4661)
Constantin Ivanov

Constantin Ivanov

Constantin "Koce" Ivanov has been a developer for over 20 years. He is known in the industry for his MS SQL and SSAS skills. He is also a .Net and Web expert. In 1996, he has achieved his Microsoft Certifications (MSCE, MCSD, MCDBA, MCT). He has been working with MS SQL since 1996 and

Other posts by Constantin Ivanov
Contact author Full biography

Please login or register to post comments.