Absence Leave Amount & Payroll Element Name

Clifford-Barrington Trett

Content

Good Day,

We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted.   This in its self is very easy and achievable.
But there is a second requirement, the requesting team then want this/these people to only be highlighted if they have a Recurring Element in the "Payroll" - "Element Name" field.

 

We have tried various different computations and realignments, also going onto Advanced Tab and then to apply sql after the relevant marker has been ticked.   And still no joy.   There are a minimum of 6 subfolders that match the SA's together as well.

 

It always errors with this "No fact table exists at the requested level of detail"

 

Any advice please,

Thank you

Puja Bharati-27866

Hi Clifford,

 

Can you please let me know what subject area you are using for fetching details of absence and recurring element. This would be helpful in analysing the issue.

 

Regards,

Puja

Manjunath Krishnappa-231872

Hi Clifford/Puja,

Would you let me know if you are aware of SQL query to join Absence plan and Payroll Element:

Refer attached screenshot for mappings.

Regards,

Manju

Peeyush Chandel

Hi Manjunath,

Did you find the query to get the absence plan and corresponding element associated?

Thanks,

Peeyush