HRSD Report - Display COE Name Instead of Technical Table Name in Legend

[Sirri]

Hi Experts,

I have created an HRSD report on the HR Case [sn_hr_core_case] table.

• Group By: Subject Person → Location → Country
• Stack By: HR Service → Topic Detail → Topic Category → COE

The report is working as expected; however, the legend displays the COE as technical table names such as:

sn_hr_core_case_benefits

sn_hr_core_case_payroll

sn_hr_core_case_global_mobility

sn_hr_core_case_talent_management

sn_hr_core_case_operation

My customer would like the report legend and visualization to display business-friendly COE names instead, for example:

HR Benefits Case

HR Payroll Case

HR Global Mobility Case

HR Talent Management Case

HR Operations Case

I can only dot-walk up to:
HR Service → Topic Detail → Topic Category → COE

and do not have the option to further dot-walk to COE Name in the report designer.

Has anyone implemented a similar requirement?

1. Is there an OOTB way to display the COE display/name value instead of the technical table name in reports?
2. Can the COE reference be configured to use a different display value?
   
   

   Any guidance or best practices would be greatly appreciated.

   Thank you!

[Anand__99 · Accepted solution]

Hi @Sirri,

You are trying to drill down to the Topic Category record COE field which stores values as internal table value and it's not of Reference type so it's showing as table's internal name.

Use the Task Type field available on the HR Core Case table.

Thanks

Anand

[Sirri]

@Anand__99 ,

Thanks lot