Hi. I have a number of measures in seconds. Id like to format them as interval time - some software has interval time formats. They would loook like โHH:MI:SSโ for hours, minutes and seconds.
How can I do this in business objects webi? Would I need to build it out by parsing out hours, the remaining minutes, then remaining seconds and built a string with the results? Or is there a format mask?
I have an attribute called [T Login] - its a number in seconds. Hereโs what I have come up with for interval formating. Its awful but works. Hoping someone else has a better way to do this.
Thanks Marek, Iโve done that. Is there a way that I can make this formula a generic function? ie format_time_as_interval(MyTimeAttribute) and it will return the string i want?
I dont relish copying and pasting the horrible formula i made all over the place.
Thanks. I guess I could create columns for hours, minutes and seconds in a derived table then the formula would not be so long and complicated. But that adds lots of attributes to my uniiverse - about 30 new measures.
I see that there you can add functions to webi but you need to do this using c++ and the webi api.