• What is the need to create a formatted measure in the cube. If you have data available as seconds you can easily cast the value as HH:MM:SS in the SSRS report.

    Raunak J