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

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
• CA Service Desk Manager
• 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>

   
   
   
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>

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

   <Please see attached file for image>

   
   
   
6. On the Definition tab under Select, specify the following:
   
   Type: Number
   Select: PdmSeconds(chg.zBackoutDuration)/60
   
   

   <Please see attached file for image>

   
   
   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>

   
   
   
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