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:
- Select the duration in hh:mi:ss metric using the column selectors in the "Criteria" tab.
- Click on "Format Column".
- The Column Properties window will open. Go to Data format.
- Check "Override Default data format".
- Select Treat Number as "Custom" and give Custom Numeric Format as "#0#:##:##".
|