SAP Knowledge Base Article - Public

2440663 - Data in matrix report excel file is inconsistent in regards to Display Options

Symptom

Matrix Report excel file shows all fields data even though all fields are not selected under Display Options of Matrix Report.

Environment

SuccessFactors BIZX: Matrix Report v12

Reproducing the Issue

1: Under Succession go to 'Performance-Potential matrix'

2: Select only one field under Display Options of matrix report, as below:

    matrixv12_icon.png

3: Matrix report shows only Gender icon and doesn't show rest of the icons in the report.

4: Click on the Export icon to export matrix report data into excel file and you would find that the exported file shows data of all fields (if it is present) even though those fields are not selected under Display Options

    matrixv12_reportIcon.png

Resolution

Excel file of matrix report is designed to show data of all fields present in Display Options that means if there are 3 fields (say Risk of Loss, Impact of Loss & Gender) and you have selected only one field (say Gender) under Display Options then also exported excel file will show data of all three fields (Risk of Loss, Impact of Loss & Gender).Display Options of matrix report doesn't control the visibililty of data on excel file, this is the expected behavior.

Keywords

  • Matrix Report excel
  • Display Option in excel report
, KBA , LOD-SF-SCM-MXG , Matrix Grid & Reports (9 Box) , How To

Product

SAP SuccessFactors HCM Core 1702