ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 4297

calendar_today

Updated On:

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. 
Powered by Wolken Software