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

Document ID : KB000004297
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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)

Environment:
This issue applies to CA PPM 14.3 (and higher)
Cause:

This is caused by CLRT-80634

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.