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