Symptom
Learning ORD Report not support 'Item' related table, for example the column 'credit hour' under 'Program Status' Schema.
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 Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Online Report Designer (Learning Live Data)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
- Login to the instance, Select Reporting > New > Canvas Report > Detailed Reporting
- Select the Learning table in order to expand the tree node
- Under the 'Program Status' Schema, we are not able to find the 'Item' table.
- Hence for example the column 'credit hour' are not support for 'Program Status' Schema
Cause
There is no "Item" table query under the object table "Program Status", and for example the "credit hour" field needs to be stored under the "Item" table.
Hence the ORD Learning live-data is not able to support the "Item" table with "Program Status".
Resolution
It's an behavior of Canvas - Online Report Designer query.
We suggest to use the Learning PRD report or Learning standard report to export the field of "Item" table query in "Program Status".
Keywords
Learning, ORD, Program Status, Item, credit hour , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-REP , Reporting Data , Product Enhancement