Export to Excel (Data only) does not show year on Quarterly TSVs

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When exporting records through ‘Export to Excel (Data Only)’ YEAR is not displayed in the Excel sheet if Period Type is set to Quarterly in the Time-scaled Value (TSV)

Steps to Reproduce:

1. Go to a portlet with the Export to Excel (Data only) option

2. Configure a TSV attribute to show Quarterly periods

One method to do this:

• Select the Options drop down for the portlet, then Configure
• Select 'Time-scaled Value'
• Change Time Scale to 'Quarter'
• Click 'Save and Return'
• From the Options drop down select 'Export to Excel (Data only)' to export the data

Expected Results: The exported file shows the Quarter number and year (Example: Q2 2016, Q3 2016, Q4 2016, Q1 2017, Q2 2017, Q3 2017)

Actual Results: The exported file shows just the Quarter number but not year (Example: Q2, Q3, Q4, Q1, Q2, Q3)

Cause

This is caused by CLRT-80634

Environment

This issue applies to CA PPM 14.3 (and higher)

Resolution

This issue is currently under review.

Workaround: Use 'Export to Excel' instead of 'Export to Excel (Data only)'. To do this: 

• From the Options drop down for the portlet, select 'Export to Excel' to export the data.