Oracle Transactional Business Intelligence

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

Categories

Earliest Working Pattern Record

Received Response
71
Views
2
Comments
Dawn Cawston - CPS
Dawn Cawston - CPS ✭✭✭
in Oracle Transactional Business Intelligence

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):

Tagged:

Answers

  • Venkat Koduvayur-Oracle
    Venkat Koduvayur-Oracle ✭✭✭

    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

  • Dawn Cawston - CPS
    Dawn Cawston - CPS ✭✭✭

    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