General OBIEE

Get Involved. Join the Conversation.

Topic

    Clifford-Barrington Trett
    Absence Leave Amount & Payroll Element Name
    Topic posted February 10, 2017 by Clifford-Barrington TrettBlue Ribbon: 750+ Points, tagged Analyses, Core HR, OTBI, Reports 
    135 Views, 1 Comment
    Title:
    Absence Leave Amount & Payroll Element Name
    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

    Comment

     

    • Puja Bharati

      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