Map ENUMS to their Display Values in BI View/SQL Reports

Idea ID 2761617

Map ENUMS to their Display Values in BI View/SQL Reports

Our Global Customer is using BI View reports on Requests which are sent directly to users. The ENUM values in these reports are hard to understand because there is no display value.

Currently there is no way to know what the ENUM display values are from within a reporting tool, and hence only the internal code is visible.

I appreciate that we can delete the "_c" from the value, but that doesn't help split the single words into legible multiple words. There is no copy of the ENUMs in a related table format.

Asking every customer to create their own mapping table seems wrong, especially when you take into account that these could be volatile ENUM lists from User Options created by power users. Either the translation* should be done by the system and the display list value visible in the BI Views, or a translation table should be available in EMS BI Views.



(*) P.S. AFAIK you can only see US-English in the BI Views reports at present, so the corresponding display label should match this language.

Tags (2)
1 Comment
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Waiting for Votes

Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.