Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Absence Leave Amount & Payroll Element Name

71
Views
3
Comments
Clifford-Barrington Trett
Clifford-Barrington Trett Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

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

Tagged:

Comments

  • Puja Bharati-27866
    Puja Bharati-27866 Rank 1 - Community Starter

    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
    Manjunath Krishnappa-231872 Rank 1 - Community Starter

    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

    Absence Element mapping.png

  • Peeyush Chandel
    Peeyush Chandel Rank 1 - Community Starter

    Hi Manjunath,

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

    Thanks,

    Peeyush