SAP Knowledge Base Article - Public

2216586 - 'Masked' fields do not appear in Table (Ad Hoc) Reporting

Symptom

In the Business Configuration UI, if a field is set to Masked = Yes, the field will disappear in Table (Ad Hoc) Reporting. Is this expected behavior for 'Masked' fields?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Core - Report Center
  • SAP SuccessFactors HXM Suite
    • Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
      •  Table/ Adhoc Reports and Builder

Resolution

Fields that are changed to be 'Masked' in the UI via Admin Tools > Business Configuration UI, will not be viewable in Ad Hoc Reporting and cannot be used within a report.

This can also be checked from Provisioning. Download the Succession Data Model and find the hris-field paycompvalue:

<hris-field id="paycompvalue" visibility="both" pii="true">

pii="true" is masking the field, this needs to be changed to pii="false" so that this field will show up in the report.

This is expected behavior.
Please note, if you use Advanced Reporting then you will be able to report on this data there.

Usually these Masked Fields are available under Person > Personal Information in Advanced Reporting (but it will still depend on specific instance configuration).
1. Create Canvas

2. Add list table
3. Add query data source > Advanced Reporting
4. Select Person realm > Personal Information
5. All masked fields with corresponding internal, external code, and picklist label columns should be available - e.g. Disability Status, Ethnic Group, Religion, Sexual Orientation

See Also

  • 2162838 - National ID Column is not visible in reporting
  • 2385771 - Masking Number Sensitive Field Data in Employee Central
  • 2162775 - How to mask National ID to be kept confidential - SuccessFactors Employee Profile

Keywords

Employee Central, EC, PII enabled fields, Mask, National ID, Social Security Number, Ad, Hoc, Report, Table, Canvas, Detailed, Advanced Reporting, sensitive fields , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , How To

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors HCM all versions