How to add Range Description in Portlet of CA PPM 15.4 when exporting to excel
book
Article ID: 131996
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity 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.