SAP Knowledge Base Article - Public

3000834 - GDPR context field missing error when previewing Story queries - People Analytics

Symptom

  • When Previewing a Story query, the following error message is shown:
    • "GDPR context field missing... "
  • Read Audit is enabled in the instance and there are Sensitive Fields configured in the instance
  • When adding Sensitive fields to Chart and Table definition in Story designer, the following error is shown:
    • "Unable to retrieve data from datasource.  Error: [ Query is not allowed since data for sensitive column [column] cannot be returned without logging ]"


      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 HXM Suite
SAP SuccessFactors People Analytics
Report Story

Reproducing the Issue

  1. Create a new Story query
  2. Select fields that are likely marked as Sensitive like e.g. National ID, Gender, Ethnicity 
  3. Preview the query
  4. The following message is shown and  "GDPR context field missing... "



Then after saving the query and building charts in designer:

  1. Add a Chart or Table component
  2. Select Measure Count and for Dimension select the Sensitive Field, e,g. Ethnicity
  3. Chart will load and eventually show an error: "Unable to retrieve data from datasource.  Error: [ Query is not allowed since data for sensitive column [column] cannot be returned without logging ]"

                


Cause

When sensitive fields are selected, user needs to select context fields as well.  The context fields exist in the same object and will be indicated in the error message.
For example, see screenshot above where it indicates the context field needed e.g. Person ID.

Resolution

  • Currently, you need to include context fields (effective date and ID of the user/person/candidate) in the reports, so they can be used for logging.  
  • So when selecting Sensitive fields, select Context fields as well.  The required context field is indicated in the error message.
  • In Story Designer, you will also have to select Sensitive Field plus the Context Field in the Chart/Table component definition.  e.g. In Dimension, select both Ethnicity and Candidate ID.
  • For more information, please see: Read Audit in People Analytics, Embedded Edition

Taking the example above, select Person ID:

Upon selecting the context field, you will notice the following info message stating that "This field indicated as Sensitive according to Data Privacy configuration."

As for Story Designer:

See Also

Read Audit in People Analytics, Embedded Edition
https://help.sap.com/viewer/2becac773fcf4f84a993f0556160d3de/latest/en-US/d1617875f4d341e3901f0c597e3fbdfb.html?q=read%20audit

Keywords

SAC GDPR, Context fields, sensitive fields, Story GDPR, read audit people analytics, data privacy, column cannot be returned without logging, read logging in story, GDPR in sotry, PARS GDPR, PARS sensitive fields and context, PAquerydesigner , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To

Product

SAP SuccessFactors HXM Core 2011