Rows getting truncated when exporting to Excel from multi-dimensional portlets

book

Article ID: 194422

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Product: Clarity PPM
Keywords: Export to Excel; 2-dimensional portlets; 3-dimensional portlets

There can be a scenario when using 2-dimensional portlets or 3-dimensional portlets, where all the rows seen in the UI do not get exported to excel.

Cause

This is caused by the number of rows limitation that is set for exporting to excel in the system. Multi-dimensional portlets can fetch more rows in the background that those that are displayed in the UI, due to their nature. The approximate number of rows that can be obtained, can be calculated by using the following formula.

Approximate rows obtained during export = (Current limit of the governor/ Total number of columns)

For example, if the Current Limit of the governor is 25000, and if we have 10 columns in the 2nd dimension, and 12 columns in the 3rd dimension that are being exported, then the Total number of columns is 120. Now, using the formula above:

Approximate rows obtained during export = 25000/120 = 208

However, this is only an approximation. There can be scenarios where the number of rows obtained are lesser or higher.

Environment

Clarity PPM 15.9.1

Resolution

For versions below 15.6.1 check E2E_MAX_ROWS and E2E_MAX_ROWS_APP property under governor.properties for the maximum number of rows that can be exported.

For versions 15.6.1 and higher, the following queries can be executed in the PPM Schema:

SELECT
    name,
    current_limit
FROM
    cmn_gov_limits
WHERE
    code = 'E2E_MAX_ROWS';
SELECT
    name,
    current_limit
FROM
    cmn_gov_limits
WHERE
    code = 'E2E_MAX_ROWS_APP';

1. Current limit of the governors can be increased by following the documentation here. Note that both E2E_MAX_ROWS and E2E_MAX_ROWS_APP governors would have to be increased.
2. Filter data to reduce the number of rows that needs to be exported or
3. Reconfigure the portlet to reduce the number of columns that are displayed