Goal Details BI Report including Employee Submission Status and Manager Approval Status fields.
I have the requirement to create a BI report for the Goals details of the employees including the Employee submission status and Manager approval status fields.
While i use the transaction hcm table in the query, i am getting multiple transactions for each goal submitted by the employees.
- Is there any way to overcome this and fetch a value as a single entry?
Also then, I am able to see the employee details who has only started the goal process in the data model. For other employees goal plan has been assigned by HR. But they did not start the goals process yet. Those employees are not fetching in the data model.