The letter case of column alias names in RSA Identity Governance and Lifecycle tabular reports is not retained

[#1]

Article Number

000037851

Applies To

RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
 

Issue

When column alias names are used in RSA Identity Governance & Lifecycle tabular reports, the letter case of the column alias name is modified when the report is saved.

For example:

1. Login to the RSA Identity Governance & Lifecycle user interface and click on Reports > Tabular.
2. Use the "Create Report " button to generate a new report.
3. Add a report name under the General Tab.
4. Add a SQL query under the Query tab to show data in the report. Make sure the query uses alias names for column headers.
5. Below is an example where the alias column name is DEPARTMENT.

Image description

5. Go to the "Display Attributes" Tab and make sure the letter case of the alias name is as per your requirement. In this example the alias name is DEPARTMENT.

Image description

6. Then Click on "Preview" or the "Run Report" option to view the results. The column name should be DEPARTMENT but it has been modified to Department.

Image description

Cause

This is a known defect reported in engineering ticket ACM-87390.

Resolution

This issue is resolved in the following RSA Identity Governance & Lifecycle patches:

• RSA Identity Governance & Lifecycle 7.0.2 P15
• RSA Identity Governance & Lifecycle 7.1.0 P08
• RSA Identity Governance & Lifecycle 7.1.1 P02