Categories
Need help with OACS Data Flow ..

Hello,
I am experiencing issues with OACS Data flow. I am trying to create an Assignment table using the HCM Cloud Subject area and then create a Prior Assignment table that stores previous information for the same employees. Now, if I make a visualization I am getting perfect results. Ie. for the first employee assignment from the Assignment table, will not have any prior assignment record in the Prior Assignment table. This is working as per my expectations and joins work perfectly fine. I can even create calculations of what got changed. However, I am designing Data Flow which reads both these tables and make new Table called Events and this will store all change flags instead of creating these calculations in each time. For example is there any change in location etc.
Now the problem I see, when flow runs, it adds extra empty rows for each Assignment record which does not happen if I create a report. So need to understand how flow executes queries differently than regular reports and how this could be fixed.
Thank you all for your help.
Best Answer
-
Screenshots explaining the issue will help.
From what I know, the way query gets generated for subject area based datasets might be different between report execution and dataflow execution. You may want look at the logical table source joins for the relevant tables and see if changing join type (from left outer to inner or right outer) makes a difference to the dataflow output.
Other comments welcomed.
1