Oracle Transactional Business Intelligence

Products Banner

Earliest Working Pattern Record

Received Response
62
Views
2
Comments

Summary:

52 week working pattern start date is not reportable at the moment.

Content (required):

Each time the employee changes to a zero hours week there is a new working pattern start date. I can pull a list off of all the working patterns assigned to each of these employees but how do I narrow it down to the first record so as to see the original start date of the overall schedule

Version (include the version you are using, if applicable):

22D soon to be 23A


Code Snippet (add any code snippets that support your topic, if applicable):

Answers

  • Hi @Dawn Cawston - CPS

    Not sure whether you are able to resolve this issue.

    If not, you can give it a try by creating a new column with expression in your report with a RANK function.

    Idea is to Rank the employees based on the working pattern start date and filter rank=1 to get the first working pattern record to see the original schedule.

    E.g.

    RANK("Working Pattern Start Date" by "Person Id")

    And further apply a filter on the report on this rank column to filter rank=1

    Hope this helps


    Regards,

    Venkat

  • Hi Venkat,

    Thank you for the suggestion which did place a ranking against the records however it has ranked the latest one as number 1 lol which means I would need to find the highest number rather than all the 1's.

    I have tried the filter to the last 1 however it then only brings back one record for one person rather than a record for all the persons.

    Will continue investigating and thanks for the input as it has helped tremendously

    Dawn