Represent Data in DD:HH:MM:SS Format in OBIEE

I used the below formula to represent the data in DD:HH:MM:SS.


TIMESTAMPADD(SQL_TSI_SECOND, CAST(("Fact - Sales Rep Call Statistics"."Total Time User Available")AS INTEGER),
TIMESTAMPADD(SQL_TSI_YEAR, CAST(("Fact - Sales Rep Call Statistics"."Total Time User Available")/86400 AS INTEGER),TIMESTAMP '2000-01-01 00:00:00')
)


we can use this either in RPD or presentation layer.
After applying above formula to the column it changes to Datetime type.


In the report go to :-

Criteria ->Column Properties ->Data Format

Select Override Default Data Format.
Date Format = Custom
Custom Date Format  = YY:HH:mm:ss
Display Time Zone    = Default
Data Time Zone Offset  = Unknown   


Oracle Business Intelligence 11.1.1.5.0

Thanks
Nawneet