If anyone faces the same issue, please can you vote for the Customer Influence Suggestion or if you know a way around this, please can you advise?
As a business we need to know when employees have moved within the business and need to report on their previous and current details and determine the effective date of change.
Further to advice from SAP, we have created a Canvas Change Report to identify people who have moved Business Units, showing their previous and new business unit and the effective date of change. We discovered that although the report successfully identified people who had moved Business Units, the effective date of change was not always accurate.
This is because the functionality within canvas report will be based on the changes/effective dates within the Job Information portlet. If there have been other subsequent changes that may not relate to Business Unit but to a different field within the Job Information, the canvas report will show the last and previous effective date regardless of what the change is, therefore we cannot accurately report on the date the Business Unit Changed.
We had wanted to use this report if successful to identify other changes such as Band Changes.
Thank you for coming back to me. I used the change button in canvas for the Business Unit field as this is the avdice that we got from SAP, however I will try your suggestion in Stories and see if we can created calculated columns and rules to identify just Business Unit changes.
Are you using the button that creates the changed field for 1 particular field only or did you go for the version where you copy the job info table + make a calculated column to get to the prior record (effective date - effective end date of prior record = 1) so that you will have the current and prior record next to each other (and then by filtering for cases where prior business unit <> current business unit rules out all other rows)? I'd always advice to also build something in that statement to check for hires + remove records that don't have the maximum sequence.
As with the approach described you should be very much able to achieve what you are saying. In stories that concepts works very similar (which I would personally recommend over canvas)