Skip to Content
0

SAP BOC Aggregation, Calculation for Time format (HH:MM:SS)

May 02, 2017 at 05:47 AM

90

avatar image

Hi All,

We are working on SAP BO Cloud having Version / Wave : 2017.07.0.

Client requirement is to have aggregated measure on Time Format (HH:MM:SS).

e.g. We have 3 dimensions Incident_ID, Downtime_Start_Date (Date hh:mm:ss) and Downtime_End_Date (Date hh:mm:ss), TRT is (Downtime_End_Date-Downtime_Start_Date
) in hh:mm:ss format.

We need to calculate MTTR which has the

formula-

Sum(TRT)/Count(Incidents)

Is it possible to get a measure in hh:mm: ss in SAP BO Cloud? and how to handle above scenario?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Henry Banks
May 02, 2017 at 11:58 AM
0

Hi,

currently, the product supports Day (Date) granularity, but to the best of my knowledge not Timestamp ...

please add your vote to the enhancement request over here: https://ideas.sap.com/D35765

regards, H

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Henry,

Thanks for the answer. Have also voted for this enhancement in Idea Place.

Regards

SK

0