Quick Start: Build Production Constraints using extended logic

Introduction

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

  • How to use workspace tables and actions in macros to augment model recipes. Specifically you will:

    • Set up an insert action.

    • Join DDM tables, both standard and the workspace tables created by the model recipe.

    • Create statements to map DDM data into the AggregateProductionConstraints table in your model.

This quick start requires that you have completed the recipe definition in the Quick Start: Create a Network Optimization model using Model Building exercise, as you will be using that recipe to generate the model and workspace tables.

You can complete the steps to add additional model data in this tutorial in approximately one hour.

Intended audience

In this course, you will view data in a Decision Data Model database. Using that data, you will set up a macro to create joins between tables and define the columns to be inserted into a table in the model. You should be familiar with basic concepts of tables and columns. An understanding of the specific DDM tables is useful, along with a general understanding of macros and associated actions.

Prerequisites

Complete the recipe definition in the Quick Start: Create a Network Optimization model using Model Building exercise. You must complete through Step 4: Create the Network Optimization model recipe to continue with this quick start.

First steps

Task 1: Generate the recipe workspace tables