Quick Start: Create a Network Optimization model using Model Building

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Quick Start: Create a Network Optimization model using Model Building

Introduction

This quick start tutorial provides you with examples of how to do the following:

Create a Decision Data Model (DDM). In order to perform this action, you must have the Customer Administrator role. If your organization currently does not have a user with this role assigned, please reach out to licensing@coupa.com.
Load data into the Decision Data Model which will be used as a data foundation for your models and analysis. In this Quick Start, you use a macro created in App Studio to populate the DDM. If you are using Data Guru in your workflow, you can alternatively use the steps outlined in Populate the DDM using Data Guru.
Leverage the cloud-based model building workflow to generate a Network Optimization model that you can use to solve a basic distribution problem. See Network strategy use case and Network Optimization.
Update and run the model in Modeler. See Running your model.
Use Modeler visualization tools to analyze the solver results. See Output tables and Maps.

You can complete the steps to build one of the models in this tutorial in approximately one hour.

Intended audience

In this course, you will import data into a Decision Data Model database. You should be familiar with basic concepts of tables and columns. You will also be filtering and aggregating table data.

A basic understanding of Supply Chain Modeler is useful.

Required files

Before you begin, save this zip archive to your machine and extract the file:

Greenfield_Advanced_DataExample.zip

The zip file contains this Excel file that is used to populate the DDM:

Greenfield_Advanced_DataExample.xlsx

Here is an overview of the quick start data in the Excel file:

A global dataset with customers and sites in many countries
27 products
310 locations
- 293 customers
- 12 distribution centers (DCs)
- 5 manufacturing locations (MFGs)
86,944 orders
- pre-aggregated into monthly buckets
- orders from January 2019 through December 2019

First steps

Task 1: Create the Decision Data Model