Importing Data for S&OP Navigator

S&OP Navigator 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 Center of Gravity configuration.

Basic configuration

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

Data import

  1. Click the arrow icon next to Download Template to download Excel Template. The file contains the relevant sheets according to your configuration in S&OP 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 Import Dataset Basic.
  4. Enter a name corresponding to a dataset to import it from the Excel file you just created. You can also enter a description.
  5. Click the plus icon next to Select Excel File. Select the Excel file that you created above.
  6. Click the upload file icon to upload the Excel file 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.
  7. After importing, click Review Data to review what was imported to the database. If everything looks fine, you can close Data Navigator.

Data Validation

S&OP Navigator 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 can then be reviewed before you begin the S&OP process.