Hi, Does anyone have any experience of using ‘or’ statements in demand flow SQL statements? We are trying to create a demand flow for demand planner client using an “or” in the sql statement to exclude some customers. Our statement is:Select contract, part_no, issue_date, issue_qty from IFSAPP.external_invent_part_issue_pub where CUSTOMER_NO <> 'CUST1' or CUSTOMER_NO <> 'CUST2' The flow doesn't error out and is created in the client, but the quantities in the created flow are still the total demand, so no exclusions are being done. Thanks
Hi, Does anyone know what the task (job) “Complete DP Data Refresh” functionally does and if it is an essential task to routinely schedule for a live running demand planner client? I have a demand planner manual that details the available demand planner tasks however it does not disclose the specific actual actions that are carried out by “Complete DP Data Refresh” task and the impacts/changes they have on the client. Thanks
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.