Finance | Project Operations, Human Resources, ...

Talent Time Off End Date Field

(0) Share

Report

Posted on by Community Member

Hi,

I am currently trying to build a report in Power BI for Talent but I am struggling to find the End Date for when an employee is off sick (see below):

I have looked in all the leave entities but I cant seem to find it?

Thanks in advance.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Christy OKane 45 on at

Like (0)

Report

RE: Talent Time Off End Date Field

Hi Jamie,

This works slightly different in CDS than in Talent.

If you want to check all the day's someone has been off sick, use the Leave Bank Transactions Entity.

That entity contains the 'Worker', 'Leave Type' and the 'Transaction Date' (This is the date they are taking off).

If someone has booked 4 days off sick, this would be stored as 4 different Leave Bank Transactions - with the number of hours taken for each day stored in the same record.

Hope this helps! :)

Regards,

Christy

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Talent Time Off End Date Field

Hi Christy,

Unfortunately that won't work for me. The first reason is I need to calculate the occurrences of sickness for a worker. If I did that in the transaction entity, that would be classed as 4 occurrences when in fact its only 1. The second reason is that my customer ideally wants to see this in an consolidate view with an end date so they can clearly see when an worker is expected back...

It has been an nightmare so far in terms of trying to report off Talent using Power BI. Is there another method to connect to Talent instead of using CDS which will give me an identical view of what I see in the front end?

Kind regards,

Was this reply helpful? Yes No
Suggested answer

Agne Petkute on at

Like (0)

Report

RE: Talent Time Off End Date Field

The "End date" on the form is a calculated field that currently is not included in any of the Leave Request data entities that exist today. As per previous comment, the best way to see day off requests is to use Leave Bank Transactions Entity which displays information per Transaction Date.

For other connection options please try collaborating with Microsoft partners as in a standard package data entities are stored in Data Management Framework or Common Data Services.

Thank you for using Microsoft Dynamics 365 Communities!

Agne Petkute

Support Engineer for Dynamics 365 for Human Resources and Dynamics 365 for Finance

Was this reply helpful? Yes No