First time, we got requirement for create IOH report for DIOR, please see more detail in attached file. We think the requirement is only require scheduler for sending DIOR data every Monday but it seems Amy need to have all other client codes show in criteria(filter) and report. Now we write query for pulling only DIOR data.
After meeting with BI team last week we committed the do process for IG confirm before estimate and develop report because in the past we got short requirement from Amy and she always change expected output after UAT that the point we failed to delivery job on time. That point may be wrong process in our team (IGIS+BI).
Now, I think she need a report to show inventory data with criteria all of client code and need a scheduler to send only DIOR data on Monday. So, We should confirm requirement with Amy on what is expected output.
Please advise and feel free to comment.