Summary and next steps

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

Summary and next steps

Congratulations on creating and running your macro! You successfully completed these activities:

Updated your existing model building recipe to generate recipe workspace tables in the DDM.
Created a macro with the insert action to populate records in the AggregateProductionConstraints table in your model.
Joined standard DDM tables and workspace tables and mapped the data to populate your model table.
Ran the macro, then used Modeler to review the results in your model.

You can take this model building exercise even further:

Edit your recipe to adjust the filter and aggregation in your model data. For example, remove the filter on Sites, aggregate the Sites by location_type and re-run the recipe. Re-run the macro, then confirm the appropriate mapping and constraint value in the Production Constraints model table.
Create macro views to generate intermediate DDM information summaries, then create a macro action to blend and insert the result into your model. For example, you can create one view to calculate average inventory and another view to calculate throughput. Create a macro action that joins the two views, calculates inventory turns, then inserts this data into the Inventory Policies in your model.