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
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
Reproducing the Issue
Code Via data model
- <hris-element id="workPermitInfo">
- <hris-field id="document-type" max-length="256" visibility="both" required="true" pii="true">
Via BCUI
- Go To BCUI
- workPermitInfo
- document-type with Masked=Yes
Report:
- Go to adhoc or canvas report
- Result: field document-type is not reportable
Cause
Example: under Work Permit Info all field set as Masked=Yes. And that’s the reason all fields are NOT visible in reporting
Resolution
This is expected behavior. pii="true" is masking the field, this needs to be changed to pii="false" so that this field will show up in the report.
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.
Example:
- Go To BCUI
- workPermitInfo
- document-type Masked=No
Or Via Data model
<hris-field id="document-type" max-length="256" visibility="both" required="true" >
Note: Another example:
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">
- This behavior doesn't apply to pay a component group amount. For example, if you mask the field amount in recurringpaycomponent in BCUI you won't be able to select it in the report, however, the Pay Component Group amount will still be visible to be selected in 'Employee pay groups Sums'.
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
- 2464127 - Cannot Mask payComponentRecurring and payComponentNonRecurringt Value in Manage Business Configuration "BCUI"
- 2336732 - Pay Component Groups missing data in Ad Hoc Reports
- 2080162 - EC Ad Hoc Report Types Explained - Employee Central
Keywords
Employee Central, EC, PII enabled fields, Mask, National ID, Social Security Number, Ad, Hoc, Report, Table, Canvas, Detailed, Advanced Reporting, sensitive fields, pii="true, pii, true, INC9160063 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , How To