Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 02, 2017 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded