Why is the Export to Excel (Data Only) option on the Project Hierarchy Tab producing multiple rows in the excel sheet for each project instance?

Article Id: 17430
Status: Published
Updated On: 14-02-2018 08:06
Legacy Id: TEC617803
Products:
CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise
Issue/Introduction:

Description:

Multiple rows are unexpectedly created in an Export to Excel (Data Only) option from the Project Hierarchy Tab.

When you view the Hierarchy page, it is expected to see two rows per child investment - one row for the Rollup row and one row for the child investment 'Self' data. The view has a rollup row so that it can 'rollup' child investments that also have child investments further into the hierarchy.

The Export to Excel action should match the rows that show in the application UI.

Steps to Reproduce:

  1. Navigate to a Project that contain Children Projects
  2. Navigate to the Project Hierarchy Tab
  3. Perform 'Export to Excel Data Only'

Expected Results: Two line items per child project - one for the rollup row, one for the 'Self' row
Actual Results: Four line items (a duplicate of each of the 2 possible expected ones)

  

Solution:

WORKAROUND:
None.  The extra rows in the export could be manually removed by the user.

STATUS/RESOLUTION:
CLRT-74778
Resolved in CA PPM 14.1

Environment:

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component: