How to get the last assignment if the worker have several records in a Analysis and Report (Goals)

Question

How to get the last assignment if the worker has several records in an Analysis and Report (Goals). We need to get the last assignment considering their last assignment approving manager and/or the line manager of the employee.

CONTENT

Hi @everyone,

We need a report to get the last assignment if the worker has several records in the Analysis and Report (Goals). Example: In the image, if we have 5 records, we want to get only 1 row with the most recent assignment of the employee, considering that they have some changes in the line manager or approving manager. Thanks and Regards

Claudia Linares L · Answer

Hi @Bhaskar Konar

Thank you so much for your help and suggestions. I reviewed the approving managers in the report all changes appear in these 5 rows from the first approving manager to the most recent manager. How to filter it?

Maybe you know how to get many goals the employee has, put the information in one column, and in another column, put, if they have more or equal to 1, have a column with Yes, but if they don't have goals or equal to 0, in the column should appear No. And then the other values in the rest of the columns.

Is it possible?

Thank you!

Claudia

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/68202#Comment_68202

Hi @Claudia Linares,

Thanks for the details.

I've tried replicating the issue in our instance but the report is working fine and it is only bringing multiple rows for few guys whoever is working for multiple departments having multiple FTEs or having multiple job title at the same time.

Can you please check your data and see if the rows are absolutely identical or some of the values like department name, manager, job title etc. are different?

If any attribute is different then we have to exclude that and see how the report is bringing data now.

Hope this help.

Thank you.

Claudia Linares L · Answer

Sure @Bhaskar Konar. I have attached the catalog. Thank you so much! I appreciate your help!

Goal Creation Report - HR V1 - Analysis.catalog

Regards

Claudia