SAP Knowledge Base Article - Public

2905097 - 9 Box Placement missing in Canvas - Advanced Reporting

Symptom


  • The "9 Box Placement History" table is not available in Advanced Reporting > User (Background Info) Realm
  • Advanced Reporting is in View Based Metadata (VBM).
  • The required configuration for this is in the data model: <background-element id="matrix1placement" type-id="###">
  • The same table is available in Ad Hoc (Report-Table) reporting and ORD Live Data (Report-Canvas Detailed Reporting)


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
Canvas Report - Advanced Reporting

Reproducing the Issue

1. Login and go to Report Center
2. Create a new Canvas report > Advanced Reporting
3. Select the User realm > User Background info
Result: "9 Box Placement History" table is missing from the list

Cause

If the this is already defined in the data model, then the most probable cause is that no Data Fields were added to the configuration.

Resolution


VBM has additional checks/requirements before creating or making objects visible in Advanced Reporting.

Check the following: 
  1. Go to Admin Center > Manage Business Configuration > Employee Profile > Background Elements > matrix1placement. 
  2. Check if there are Data Fields defined

The reason 9 Box Placement History object was not available, is because no fields were defined in the data model. 


Only system (background) elements are supposed to not have fields. For others, VBM will not create an object if there are no fields accosted with that background element.  For Consumer Based Metadata (CBM) previously, this was not required so the object may have been visible before. 

The suggested solution is to add Data Fields to the data model for matrix1placement.

After you have applied the change, you can refresh  metadata cache from your end via Canvas > Admin > Purge Advanced Reporting Metadata Cache (see https://launchpad.support.sap.com/#/notes/2776882).  Then 9 Box Place should be available under User Background Info.

See Also

Keywords

9-box, matrix1placement, realms, VBM, matrix grid object, nine box, 9-box reports, Advanced Reporting , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Core 1911