Export to CSV Per-Period Metrics are blank if 'Totals' column is not present

book

Article ID: 192265

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

SUMMARY:
The Project STAFF and ASSIGNMENTS Grid utilizes the 'Totals' and 'Per-Period Metrics' columns.
If the 'Totals' column AND the 'Per-Period Metrics' columns are configured on the grid the CSV Export works as expected and you see all the data.
If you don't have the 'Totals' column configured in the grid, the Export does not work as expected --- all the per-period metrics columns are blank.

STEPS TO REPRODUCE:
NOTE: These steps are for the Project STAFF Grid - repeat the same steps for ASSIGNMENTS grid using any of the metric fields (ETC, ETC Cost, Actuals, Actual Cost)

  1. Go to Project STAFF grid
  2. Open Column Panel and add 'Totals' - 'Allocations' field
  3. Go to View Options and select 
    1. PER PERIOD METRIC = 'Allocations' (don't use Hard Allocations ; there is a current issue with that one)
    2. PERIOD TYPE = any configured type - use Months
    3. START / END Dates - use dates that fall within the project
  4. If the user uses FTE - set the decimal display option or change user's SETTINGS GENERAL to use Hours
  5. EXPORT TO CSV
  6. Look at the output - the data is shown as expected for the PER-PERIOD METRICS columns
  7. Remove the 'Totals' column
  8. EXPORT TO CSV

EXPECTED: to see data in the PER-PERIOD METRICS columns in the CSV output
ACTUAL: the PER-PERIOD cells are blank in the CSV output

WORKAROUND: Add the 'Totals' column to the grid layout before using Export to CSV.

Cause

This is caused by Defect DE49460

Environment

Clarity PPM 15.x

Resolution

Defect DE49460 is solved in 15.7.1.4 and 15.8.1