How can I get current date on hour-minutes-seconds (06:13:47) format in MDX?
I'm trying to create a 'New Calculated Member' on the 'Calculations' Options inside the Cube used.
CALCULATE; CREATE MEMBER CURRENTCUBE.[Measures].AverageAnalysisTimeFormatted AS FORMAT([Measures].[AverageAnalysisTime], "HH:MM:SS"), VISIBLE = 1 ;
My current result inside as it is (without the Calculated Member) is AnalysisTime = 1574,30
Which is 1574 seconds, or 26 minutes.