Cannot report on field "Planned End Date" in Global Assignment in Adhoc Report
Cannot report on Global Assignment Detail fields in Adhoc Report
- Employee central
- Advance Reporting
- Adhoc Report
Reproducing the Issue
To recreate the problem,
1. Open ad hoc reporting then select either the "Person and Employment Export" or "Person and Employment (As of date)" report templates
2. Then attempt to select Global Assignment Information for the reporting columns.
Notice no Global Assignment Details are selectable.
The problem occurs because Global Assignment Information fields are not reportable within the Ad Hoc Reporting tool.
In order to report on Global Assignment Information fields, you will need to use Online Report Designer, ORD, which does support reporting of these fields. You must have ORD enabled on your system to report on EC related data, including Global Assignment Information.
Example: Run a Report on Global Assignment Information Detail in Advance Reporting
- Go to Report Centre then selct Report canvas
- Give a name and create
- Click on Edit Query
- Select: Employemnt
- Select and Drag
- Users Sys Info and Global Assigment Deatail
Advance Reporting, Adhoc Report, Global Assignment Detail, Planned End Date , KBA , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC , Employee Central , LOD-SF-EC-ROD , Reporting/Analytics (ODS) , LOD-SF-EC-CGA , Global Assignments/ Concurrent Employment , Problem