How to add Range Description in Portlet of CA PPM 15.4 when exporting to excel

Article Id: 131996

Status: Published

Updated On: 09-05-2019 11:34

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

When I export to Excel and my attribute is configured to use Range Description in Portlet of CA PPM 15.4 I unable to see it, I only see values like 10, 20 etc...

Environment:

Release:
Component: ODSTU

Resolution:

Export of 'Schedule' description from 'Status Report Indicators' portlet can't be achieved with the current design. Reason attribute has a 'Data type = Number' which is associated with Color mapping.

What is possible is you can setup Portlet to display both 'Image' & 'Range Description'; but when you export to excel 'Range Description' won't be part of it. To set this up you can click on the 'Option' icon on the top right corner of 'Status Report Indicators' portlet.
- From the drop down click on 'Configure'
- From the drop down for 'List Column Section' click on 'Fields'
- Click on Properties icon for 'Schedule' attribute
- On the popup screen select the check box for 'Range Description' under Display Elements

NOTE: This is just a Visual option for Users when they explore 'Status Report Indicators' portlet; exporting it to an Excel file will only include its Numeric value and its associated Color mapping.