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

book

Article ID: 50648

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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.

    <Please see attached file for image>

    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).

    <Please see attached file for image>

    Figure 2

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

    <Please see attached file for image>

    Figure 3

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

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

    <Please see attached file for image>

    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

    <Please see attached file for image>

    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.

Environment

Release:
Component: ARGIS

Attachments

1558698877700000050648_sktwi1f5rjvs16ofl.gif get_app
1558698875991000050648_sktwi1f5rjvs16ofk.gif get_app
1558698874189000050648_sktwi1f5rjvs16ofj.gif get_app
1558698872510000050648_sktwi1f5rjvs16ofi.gif get_app
1558698870403000050648_sktwi1f5rjvs16ofh.gif get_app