Importing Data for IBP

IBP can read configurations and datasets from the SC Navigator database. To import your data to this database, you need to use Data Navigator. Please see the Data Navigator documentation for more details about this app.

Please follow the steps below to import your data and create your S&OP configuration.

Basic configuration

  1. Launch Data Navigator.
  2. Select IBP as the application type.
  3. In the Menu bar, select IBP Data Wizard.
  4. Read the instructions and click Start wizard.

Data import

  1. On page Generate Excel Template, click the arrow icon next to Download Template to download Excel Template. The file contains the relevant sheets according to your configuration in IBP Data Wizard.
  2. Open Excel Template and enter the required data, e.g. your Location Data. Fill in all sheets and save the Excel file.
  3. Go back to Data Navigator and click page Import Dataset.
  4. Click the plus icon next to Select Excel File. Select the Excel file that you created above.
  5. If the file is uploaded successfully, a success dialog will pop up to ask review data or save data. If something goes wrong, data issues will be displayed in a dialog page. You may still ignore warnings and save data.
  6. Enter a name corresponding to a dataset to import it from the Excel file you just created. You can also enter a description.
  7. Click the save button to save to the database. Data Navigator returns a success message. If something goes wrong, error/warning message(s) will appear at the bottom of the page. The Import Dataset page provides information to correct the issues, or explains why the data cannot be imported.
  8. After importing, click Review Data to review what was imported to the database. If everything looks fine, you can close Data Navigator.

Data Validation

A user logged in as S&OP Process Coordinator will load a configuration and dataset by following prompts on the Home page, or from the Menu under Settings. Data validation issues will appear upon loading a dataset.