How do I stop customized field with a type 'DURATION' being displayed as a Date in a BOXI report?

Document ID : KB000050648
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

A customized field with the type of "DURATION" is displayed as date in BOXI reports. This document shows the steps required to display data of the custom field correctly.

Solution:

  1. On the BOXI Server, go to Start > Programs > Business Objects group and launch the Designer.

  2. Select File -> Import

  3. Make sure CA Universes and CA Service Desk are selected and click ok.

    Figure 1

  4. Once the Universe is imported, in the left pane, find the folder where the customized field exists and locate the Duration field (zbackoutduration in the example).

    Figure 2

  5. Right click on the Duration field and select Object Properties.

    Figure 3

  6. On the Definition tab under Select, specify the following:

    Type: Number
    Select: PdmSeconds(chg.zBackoutDuration)/60

    Figure 4

    NOTE: If you do not specify "/60", data will be displayed in seconds rather than minutes.

  7. Click Ok to close the Object Properties dialog.

  8. Click File -> Export and select Continue on the save dialog

    Figure 5

  9. Make sure Domain is /CA Universes. Highlight all Groups and click Ok.

    Once you see that the Universe is successfully exported, go back to Infoview and to your report and remove the duration field and try adding it again from the universe. Then verify that the duration field displays as a number rather than a date.