Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle BI Applications Consumer >

Viewing Duration Metrics in hh:mi:ss Format in Oracle BI Answers

The Oracle Business Intelligence Applications analytic repository (.rpd) has several duration metric in the "Fact - Service - Contact Center Performance" and "Fact - Service - Rep Activities" subject areas. Most of these duration metrics also have a version that is a pre-formatted number to be displayed in the hh:mi:ss format. In order to view these duration metrics in hh:mi:ss format in an Oracle BI Answers report, do the following:

1. Select the duration in hh:mi:ss metric using the column selectors in the "Criteria" tab.
2. Click on "Format Column".
3. The Column Properties window will open. Go to Data format.
4. Check "Override Default data format".
5. Select Treat Number as "Custom" and give Custom Numeric Format as "#0#:##:##".