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

Article Id: 4297
Status: Published
Updated On: 14-02-2018 07:54
Legacy Id: TEC1285976
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
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.