Important notes:

• Several columns are no longer available in the user interface. These are columns that are not currently in use by a solver. The columns are still defined in the model database tables. Review columns that have a Description of Change value of "Removed from UI (not currently in use)".

• Please review columns that have a Description of Change value of "Data Type change", "Column removed" or "Change in Required". If you use these columns in a workflow, you may need to adjust the workflow to support the new data type or requirement.

Input Tables

Table	Column	Description of Change	Model Database Table Name	Model Database Column Name	Data Type	Required
Input Tables
OptionsSnapshot (Table not displayed in the UI)	ID	New table/column	OptionsSnapshot	ID	Integer	Yes
	SnapshotID	New table/column	OptionsSnapshot	SnapshotID	GUID	Yes
	Option	New table/column	OptionsSnapshot	Option	Text	Yes
	Value	New table/column	OptionsSnapshot	Value	Text	No
SnapshotLookup (Table not displayed in the UI)	ID	New table/column	SnapshotLookup	ID	Integer	Yes
	SnapshotName	New table/column	SnapshotLookup	SnapshotName	Text	Yes
	SnapshotID	New table/column	SnapshotLookup	SnapshotID	GUID	Yes
	Type	New table/column	SnapshotLookup	Type	Text	Yes

Output Tables

Table	Column	Description of Change	Model Database Table Name	Model Database Column Name	Data Type
Output Tables
Work Center Queue Depth Detail	Product	Renamed to Work Center	SimulationOutputWorkCenterQueueDepthDetail	WORKCENTER	Text
Cost To Serve Details	Refundable Tax	New column	OptimizationOutputNetworkPathDetails	RefundableTax	Money
	Non-Refundable Tax	New column	OptimizationOutputNetworkPathDetails	NonRefundableTax	Money
Path Summary	Refundable Tax	New column	OutputPathsSummary	RefundableTax	Money
	Non-Refundable Tax	New column	OutputPathsSummary	NonRefundableTax	Money
OptimizationOutputCostAllocation_Lane (Table not displayed in the UI)	Refundable Tax	New column (not displayed in the UI)	OptimizationOutputCostAllocation_Lane	RefundableTax	Money
	Non-Refundable Tax	New column (not displayed in the UI)	OptimizationOutputCostAllocation_Lane	NonRefundableTax	Money
Cost To Serve Customer Summary	Customer	New table/column	OutputCostToServeCustomerSummary	CustomerName	Text
	Total Paths	New table/column	OutputCostToServeCustomerSummary	TotalPath	Float
	Max Path Length	New table/column	OutputCostToServeCustomerSummary	MaxPathLength	Float
	Min Path Length	New table/column	OutputCostToServeCustomerSummary	MinPathLength	Float
	Average Path Length	New table/column	OutputCostToServeCustomerSummary	AvgPathLength	Float
	Total Revenue	New table/column	OutputCostToServeCustomerSummary	TotalRevenue	Money
	Total Cost	New table/column	OutputCostToServeCustomerSummary	TotalCost	Money
	Total Profit	New table/column	OutputCostToServeCustomerSummary	TotalProfit	Money
	Total Lane Cost	New table/column	OutputCostToServeCustomerSummary	TotalLaneCost	Money
	Total Site Cost	New table/column	OutputCostToServeCustomerSummary	TotalSiteCost	Money
	Total Site Product Cost	New table/column	OutputCostToServeCustomerSummary	TotalSiteProductCost	Money
	Total Other Cost	New table/column	OutputCostToServeCustomerSummary	TotalOtherCost	Money
	Total Flow Rate	New table/column	OutputCostToServeCustomerSummary	TotalFlowRate	Float
	Total Revenue Rate	New table/column	OutputCostToServeCustomerSummary	TotalRevenueRate	Float
	Total Profit Rate	New table/column	OutputCostToServeCustomerSummary	TotalProfitRate	Float
	Total Weighted Service Time	New table/column	OutputCostToServeCustomerSummary	TotalWeightedServiceTime	Float
	Total Flow Risk	New table/column	OutputCostToServeCustomerSummary	TotalFlowRisk	Float
	Total Revenue Risk	New table/column	OutputCostToServeCustomerSummary	TotalRevenueRisk	Float
	Total Profit Risk	New table/column	OutputCostToServeCustomerSummary	TotalProfitRisk	Float
	Scenario ID	New table/column	OutputCostToServeCustomerSummary	ScenarioID	Integer
	Sub-Scenario ID	New table/column	OutputCostToServeCustomerSummary	StepNumber	Integer
Cost To Serve Finished Goods Summary	Product	New table/column	OutputCostToServeFinishedGoodsSummary	ProductName	Text
	Total Paths	New table/column	OutputCostToServeFinishedGoodsSummary	TotalPath	Float
	Max Path Length	New table/column	OutputCostToServeFinishedGoodsSummary	MaxPathLength	Float
	Min Path Length	New table/column	OutputCostToServeFinishedGoodsSummary	MinPathLength	Float
	Average Path Length	New table/column	OutputCostToServeFinishedGoodsSummary	AvgPathLength	Float
	Total Revenue	New table/column	OutputCostToServeFinishedGoodsSummary	TotalRevenue	Money
	Total Cost	New table/column	OutputCostToServeFinishedGoodsSummary	TotalCost	Money
	Total Profit	New table/column	OutputCostToServeFinishedGoodsSummary	TotalProfit	Money
	Total Lane Cost	New table/column	OutputCostToServeFinishedGoodsSummary	TotalLaneCost	Money
	Total Site Cost	New table/column	OutputCostToServeFinishedGoodsSummary	TotalSiteCost	Money
	Total Site Product Cost	New table/column	OutputCostToServeFinishedGoodsSummary	TotalSiteProductCost	Money
	Total Other Cost	New table/column	OutputCostToServeFinishedGoodsSummary	TotalOtherCost	Money
	Total Flow Rate	New table/column	OutputCostToServeFinishedGoodsSummary	TotalFlowRate	Float
	Total Revenue Rate	New table/column	OutputCostToServeFinishedGoodsSummary	TotalRevenueRate	Float
	Total Profit Rate	New table/column	OutputCostToServeFinishedGoodsSummary	TotalProfitRate	Float
	Total Weighted Service Time	New table/column	OutputCostToServeFinishedGoodsSummary	TotalWeightedServiceTime	Float
	Total Flow Risk	New table/column	OutputCostToServeFinishedGoodsSummary	TotalFlowRisk	Float
	Total Revenue Risk	New table/column	OutputCostToServeFinishedGoodsSummary	TotalRevenueRisk	Float
	Total Profit Risk	New table/column	OutputCostToServeFinishedGoodsSummary	TotalProfitRisk	Float
	Scenario ID	New table/column	OutputCostToServeFinishedGoodsSummary	ScenarioID	Integer
	Sub-Scenario ID	New table/column	OutputCostToServeFinishedGoodsSummary	StepNumber	Integer

Support for SQL Server 2022

You can upload SQL Server 2022 format databases to llama.ai. These assets work in the various platform applications, such as Modeler and App Studio. When you copy the asset, the copy will be SQL Server 2022, and when you download a SQL Server 2022 asset, it retains the SQL version.

Keep in mind that new assets created on the platform are currently SQL Server 2019.

New Data Flows tool

Modelers require a space and the capability to blend and prepare model data for modeling and apps-based use cases. Data Flows provides a platform-based solution, integrating seamless ETL (extract, transform, and load) functionality with the ability to create and execute end-to-end modeling and app workflows.

Data Flows enable you to link various assets, such as models, user defined databases and decision data models (DDMs), perform data transformations and migrate data between the assets. With a drag and drop interface, you can create repeatable data workflows made up of various actions that interact with your modeling assets.

See Building Data Flows.

SCDP 41.4.0 Transient schema support for Data Flows actions

When creating your data flows, you may have actions that are dependent for their schema upon the results of an upstream action. Data flows provides a “transient schema” which tracks the schema that is yet to be created and makes that available without requiring action execution.

SCDP 41.4.0 Link colors reflect parent-child action relationship

Link colors indicate the relationship between parent and child actions, based on the lookup, input, target, and output properties of each action. Specific combinations of actions and properties result in green links rather than black.

SCDP 41.4.0 Improved delimited file configuration

Configuration for delimited file assets is simplified and enhanced. Click on a column header in the table display to configure an individual column. Multi-column edit enables configuration of any number of columns to set data type and optional format.

SCDP 41.4.0 Action panel display options

You can display the set of Data Flows actions as a list with name and descriptions, a compact list of action names, or a grid with action items.

SCDP 41.2.0View how Data Flows actions use your tables and connections

You can view how your data flow actions use your tables and connections by clicking the Table Summary icon . This displays a list of list of affected tables and how they are used, as well as a list of database connections. Clicking a table or connection updates the canvas tiles to indicate how each action affects the table or connection.

Tables may be used as follows:

• Input: the table is used as source data

• Output: the table is created by the action and data is written to the new table

• Lookup: the table is used to find data from other tables

• Target: data is written to the existing table

• Delete: the table is deleted by the action

See Viewing how tables and connections are used by Data Flows actions.

App Studio

Better file naming for Grid exports

The Grid widget Export feature now names the export file using the grid name and the date and time of the export.

Easier Bulk Updates to columns in grids

When bulk updating a Grid widget column, you can now search the Values field as a searchable dropdown list. The list filters dynamically as you type.

Demand Modeler

Forecast Hub data grid update

The Forecast Hub data table includes a column called Historical Demand/Forecast to indicate whether the data is historical demand or forecasted data.

Setting the day of the week when aggregation occurs

You can set the day of the week on which weekly aggregation occurs using the Day of Aggregation advanced parameter. The default is Mon for Monday. Valid values are Mon, Tue, Wed, Thu, Fri, Sat, Sun.

Filtering the Error Metrics and Causal Analysis grids by columns

You can filter the grids on the Forecast Accuracy page’s Error Metrics grid and the Causal Analysis page’s grid by the following columns.

Error Metrics:

• Timestamp

• Model Name

• Actual

• Error Avg

• Absolute Error Avg

• Squared Error Avg

Causal Analysis:

• Feature Name

• Feature Type

• Correlation Description

• Lag Number

• Correlation with Demand

Modeler

SCDP 41.6.0 Display scenario item details from scenarios

In both Scenarios and Rapid Solve Scenarios, turn on the Show Scenario Item Detail toggle to display details about the scenario items. The information includes: the table, filter name, filter criteria, field, and field value(s) with the operator. Details are displayed for both Available Items and Selected Items.

SCDP 41.6.0 Ability to edit scenario items from scenarios

In both Scenarios and Rapid Solve Scenarios, select the arrow on the right of the scenario item or double-click the scenario item to open that item in a tab for editing. You can edit scenario items from the Available Items and the Selected Items lists. If you are editing a rapid eligible scenario item from a Rapid Solve Scenario, the "Show Only Rapid Eligible Tables and Fields" toggle is ON in the scenario item tab.

SCDP 41.3.0 Ability to create scenario items in scenarios

Both the Scenarios and Rapid Solve Scenarios include a New Scenario Item button that lets you create scenario items from within the scenario definition. When you click this button, a new scenario item tab is opened. If you are creating a scenario item from a Rapid Solve Scenario, the "Show Only Rapid Eligible Tables and Fields" toggle is ON and disabled, limiting the selection to rapid eligible tables and fields. New scenario items are added to then end of the Selected Items list and can be reordered as needed.

When you create new scenario items, either from a scenario or in the Scenario Items section of the navigation pane, default values are provided for the table, field, operator, and value, and the scenario item is valid. These values are Product (Table), Status (Field), = (Operator), and Include (Value). When creating a new scenario item from a Rapid Solve Scenario, the default values are Customer Demand (Table), Quantity (Field), * (Operator), and 1 (Value) to ensure rapid eligibility.

SCDP 41.2.0 Additional marker shapes for map point layers

Map markers offer a variety of shapes that you can assign to point layers. The markers, such as stars, triangles, diamonds, and arrows support settings for size, color, borders, and opacity.

SCDP 41.1.0 Enhanced data visualization features in Modeler

Data Visualizations has been moved to the Integrate section of the Modeler navigation bar. You can open visualization workbooks in the Data Visualizations interface or in tabs in the Modeler interface. Workbooks support the same editing features in Modeler tabs as in the Data Visualizations interface. This includes the ability to refresh data in the workbook and to control display of the toolbar and header. In addition, you can duplicate workbooks within the current model or select another model as the target for the duplicated workbook.

Platform support for model versions

The Supply Chain platform supports solving models with a database schema of up to 1 year old. As of the January 2025 release (R41), this includes models from releases back to the R39 release (schema version 407000). Models with unsupported schemas must be upgraded before solving, modeling, using with apps, or solving on the cloud. As of R41, support is ending for the following schema version and older model schemas:

• Release R38 (schema 406000)

Removal of Modeler Graphs

As part of the transition to the Data Visualizations feature, Coupa removed the Modeler Graphs feature on the Supply Chain platform on January 18, 2025.

This FAQ page in our online Coupa Community provides further information about the discontinuation of Modeler Graphs to address any questions or concerns you may have.

Modeler default for Network Optimization is now the Next Generation solver

When solving using Network Optimization, the default solving engine now uses the Next Generation (Next Gen) solver. Previously, the Next Gen solver was available but not selected by default. This solver provides improved performance for most models and a “round robin” method of processing requests. It currently applies only to Network Optimization.

If you want to use the previous solvers, turn off the “Enable Next Generation Solving Engine” switch in the Modeler Launch Pad before running scenarios.

Rapid Network Explorer

When building scenarios to evaluate changes to your network, long running scenarios can be a challenge to providing results to key stakeholders in a timely manner. The Rapid Network Explorer (RNE) is designed to support small changes, such as adjustments to transportation or production costs, then solving without generating the full model again. This significantly reduces the time to return results, allowing you to explore a number of changes in a short period of time.

Run Network Optimization on a scenario to be used as the base data for RNE. You then define rapid scenarios, with items that adjust specific RNE eligible columns, such as demand quantity and variable transportation cost. When you run the Rapid Solve problem type, the items in the rapid scenario are applied to the base scenario results and output is returned to the model.

The RNE Intensity option lets you control the extent to which decision variables in the base scenario are fixed when running the rapid solve. A higher value means more decision variables are constrained, leading to a quicker solution. A lower value opens up the base data by not constraining as many decision variables.

See Rapid Network Explorer.

Optimize networks to minimize risk level

When you populate Risk Profiles in your model, Network Optimization outputs a composite risk score for the sites in the network. However, this risk score does not affect the optimization results. In this release, you can use risk as a constraint and as an objective for Network Optimization. Updates to input tables, sequential objectives, constraints, and parameters enable Network Optimization to minimize risk and respect maximum risk levels.

You can define a Maximum Risk constraint value per product in the Products table. The product risk is the weighted average of the product flow through the sites based on each site’s risk score. The site risk score is based on the weighted average of user-entered scores in the Risk Profile table when a Risk Profile is assigned to a site. You can also constrain risk at the network level with the Maximum Network Risk option in Network Optimization Options.

To apply risk as part of the objective, create one or more Sequential Objective records targeting the new risk-based objectives, then run Sequential Optimization:

• Total Network Risk

• Maximum Network Risk

• Maximum Product Risk

New output tables and columns report the aggregated risk scores and provide percentage summaries of high, moderate, and low risk flows in the solution.

See Risk analysis and minimizing risk.

Changes to scores in Risk Profiles

The four Custom Score columns in the Risk Profiles table are now evaluated on a scale of 0 to 100 where higher scores signify higher risk. Previously, a high score signified a low risk.

Cost To Serve features

Additional columns are available in cost to serve-related output tables. The Site Variable Cost and Space Expansion Cost are now included in the Network Path Details and Path Summary output tables.

Space Expansion Cost is also included as an input when running Cost To Serve Analysis.

New configuration parameters have been added for Cost To Serve Analysis:

• CTSFilter_TopProdsByCostPercentage - The final products are ranked by the cost related to them, then the percentage entered for this parameter is used to select the top x products. Cost To Serve Analysis is run on this smaller set of products, resulting in fewer paths in the output. The value is between 0 and 1.

• CTSFilter_TopProdsByProfitPercentage - The final products are ranked by the profit related to them, then the percentage entered for this parameter is used to select the top x products. Cost To Serve Analysis is run on this smaller set of products, resulting in fewer paths in the output. The value is between 0 and 1.

Populate these parameters in the Config_NO table and set the Status to “Include” to use them in Cost To Serve Analysis.

Network Optimization dynamic termination settings

Network Optimization supports dynamic termination settings, enabling you to stop a solve based on settings such as the maximum time since the last solution was found, the maximum percent of memory consumed by the solve, and others. These settings support better tuning of solve terminations.

The settings are available on the Termination Settings tab in Network Optimization Options:

• Maximum Time Since Last Solution – Stops the model after no better solution has been found for the time entered (in seconds).

• Maximum Time Since Last Improvement – Stops the model after no better gap has been found for the time entered (in seconds).

• Dynamic Percent Gap - Allows the termination percent gap to change over the solving process. Define a two-step function where the first value in each pair is the run time (in seconds) and the second is the gap percentage.

• Dynamic Absolute Gap - Allows the termination percent gap to change over the solving process. Define a two-step function where the first value in each pair is the run time (in seconds) and the second is the absolute gap.

• Max Memory Consumption Percent - Forces the solve to stop after system memory consumption reaches the percentage defined by the limit.

Bing support in Transit Matrix Calculate Paths

Bing is supported as the default provider when you Calculate Paths in the Transit Matrix table. When using Bing, you also have the option to “Avoid Ferry Route Calculation If Possible”. When this option is selected, Bing seeks routes that do not use ferries.

Display list of visualizations associated with a model

Data Visualizations now supports three workbooks per model asset. In Modeler, when you select Data Visualizations, workbooks that are currently defined for the model are displayed in the Data Visualization pane. To open a workbook, click on the name – the workbook is opened in Data Visualizations in a new browser tab.

Click New Workbook to create a new workbook for the model.

NO – IO Conversion and Model Expansion support solver selection

The two model transformations, NO – IO Conversion and Model Expansion, now provide solving engine selection when the model is run. This enables you to use more powerful solving engines for complex, memory intensive models.

Supply Chain Home Page

Data Visualizations

SCDP 41.1.0Hide the Qlik toolbar and header

To increase the available space for widgets on Data Visualizations sheets, the Qlik toolbar and header can be hidden when needed. Two new toggle buttons, Hide/Show Toolbar and Hide/Show Header, control the toolbar and header display.

Multiple workbooks per database asset

Data Visualizations now supports up to three workbooks associated with a Supply Chain Guru model. This allows you to create a separate workbook for each of the technology types (Network Optimization, Inventory Optimization, and Transportation Optimization). You can, however, use the three available workbooks in any combination necessary. Workbooks are limited to three per model, not per technology type. As an example, you might have two Network Optimization workbooks and one Transportation Optimization workbook.

When you open Data Visualizations while working with a model in Modeler, you can choose which workbook you want to open if more than one workbook is associated with the model.

Notifying users of Qlik maintenance windows

Data Visualizations now includes banner notifications to announce events such as Qlik maintenance windows. The notifications appear at the top of the Data Visualizations home page as a banner. You can dismiss banners, with the exception of System Unavailable messages. During Qlik maintenance windows, workbooks are not available.

Greenfield summary tables added

The Greenfield summary tables have been added to the load script. These tables are:

• Greenfield Flows

• Greenfield Service Summary

• Greenfield Sites

• Greenfield Sites Summary

• Greenfield Summary

These tables are available with the Network Optimization and Inventory Optimization templates, including the new Greenfield Flows Dashboard template.

New worksheet templates

Data Visualizations now include the following standard templates. You can use these templates to quickly create customized worksheets in your Data Visualizations workbooks.

• Greenfield Flows Dashboard

• Cost to Serve Analysis

• Production Dashboard

• Production Summary Comparison

• Inventory Summary Comparison — update to existing template

Grouped templates in the Public Sheets section

The worksheet templates are now grouped in the Public Sheets section in order to make them easier to find. The groups are:

NO Single Scenario Templates

• Network Summary Dashboard

• Customer Flows Dashboard

• Intersite Flows Dashboard

• Production Flows Dashboard

NO Comparison Templates

• Network Summary Comparison

• Customer Flows Comparison

• Intersite Flows Comparison

• Production Flows Comparison

IO Demand Templates

• Customer Demand Report

• Site Demand Report

Inventory Optimization - Inventory Policy/Summary Templates

• Inventory Summary Comparison

• Inventory Policy Overview

• Inventory Policy Details

Production

• Production Summary Comparison

• Multi-Period Production Dashboard

Greenfield

• Greenfield Flows Dashboard

Cost to Serve

• Cost to Serve Analysis

Grouping workbooks on the home page

On the Data Visualizations home page, you can now create groupings for your Private sheets to make them easier to find. Once you have grouped your Private sheets, you can make the group public if necessary.

Demand Modeler

Purging old scenario runs

In order to maintain database efficiency, Demand Modeler automatically deletes data from scenario runs older than the last successfully completed run. The latest scenario run for each scenario will be preserved.

Output Reports for Explainable AI

The Correlation Analysis tab of Demand Modeler has been renamed to Causal Analysis, and a new Variable Importance sub-tab has been added. These changes help modelers discover the top causals that are influencing the forecast. For every time series chosen by the modeler in the Demand Modeler filters, the new Causal Influence bar chart on the Variable Importance sub-tab displays the top causals that are influencing the forecast, in decreasing order of influence. A detail table below the chart displays the corresponding details for the chart.

For more information on Coupa AI, see AI Trust Center and Coupa Artificial Intelligence Features.

App Studio

Updating apps in production using draft apps

You can now update an existing App Studio app using a draft copy of the app, rather than updating the live app. A draft copy of an app is an exact copy of an app that is inaccessible to app users, which an app designer can use to make and test changes safely without affecting the live version of the app. All assets for the app (app boards, widgets, user defined databases, dynamic views, and sessions) except the Decision Data Model (DDM) are copied, and the draft app only uses the copies. The draft app will reference the live DDM.

For example, you can:

• Make changes to app boards such as adding or changing widgets
• Add or remove app boards
• Add columns and tables to the database

When the changes are finalized in the live app, the draft app is archived and the database for the draft is deleted.

The database copy limit is 20 GB. If the database is larger than 20 GB, the schema of the database is copied, instead.

If you are interested in this feature, please contact Coupa Support for access.

Copying databases larger than 20GB

You can now copy databases whose sizes are greater than or equal to 20GB.

Data Grid Improvements

You can now copy values from a Grid or Pivot Grid widget regardless of the editability conditions of a particular column. Values can be copied from a single cell across data grids and pivot grids.

A new Clear All Filters button is available on the Grid widget toolbar. When you click Clear All Filters, all active filters in the data grid are removed.

Modeler

Platform support for model versions

The Supply Chain platform supports solving models with a database schema of up to 1 year old. As of the September 2024 release (R40), this includes models from releases back to the R38 release (schema version 406000). Models with unsupported schemas must be upgraded prior to solving, modeling, using with apps or solving on the cloud. As of R40, support is ending for the following schema version, as well as older model schemas:

• Release R37 (schema 405000)

Next generation solver for Network Optimization

As Coupa continues to innovate and deliver faster solutions to our customers, Network Optimization now offers a next generation (Next Gen) deployment of the solver as an option when running models in Modeler. The Next Gen solver offers the same Network Optimization technology, with improvements to the processing of models.

Benefits of the Next Gen solver include:

• Improved performance – In many cases, models solve faster with the Next Gen solver than the previous solver. This may not affect models that already run quickly but is more evident with longer running models.

• “Round Robin” processing of requests – The Next Gen solver will loop through requests by customer. This prevents cases where a customer sends a large number of requests that effectively block the next customer’s requests from starting right away. The solver executes a request from the first customer, then moves on to the next customer and executes a request. This continues for all customers in the queue. Once it has been through all customers, it loops back to the first customer and will continue to take requests in this manner as long as there is available memory and CPU. As resources are freed up, it processes additional requests.

• Removal of strict limitation on the maximum number of design engines – The Next Gen solver will not have the same cap of the available number of design engines that can be accessed at one time. As a result, the Next Gen solver can scale more effectively than the previous solver when large numbers of requests are made.

Transit Matrix route calculation

The Transit Matrix provides a way to use accurate road distance and travel time values when solving your model. You can now generate source-destination connections in the Transit Matrix table in Modeler using either Transportation Policies or Site and Customer locations. Filters let you control which connections are generated. Once the Transit Matrix table has been populated, you can then use Straight Line Plus Circuity to calculate the Distance and Travel Time on the route.

Cost To Serve updates

New output tables provide additional information pertaining to the enhanced Cost To Serve Analysis. The Cost To Serve Network Summary gives scenario-level metrics about the paths created by Cost To Serve, including path lengths, costs, revenue, and profit values. The Path Summary has path-level details, including many cost metrics, revenue, and profit values.

Sequential Objectives for spatial modeling

A set of objectives is available in the Sequential Objectives table for use with spatial modeling:

• Maximum Site Expansion

• Minimum Site Expansion

• Maximum Storage Space Expansion

• Minimum Storage Space Expansion

• Maximum Shipping Space Expansion

• Minimum Shipping Space Expansion

In support of these objectives, Storage Space and Shipping Space columns have been added to the Sequential Objectives table.

Multi-stop dock door scheduling

Dock door scheduling is now supported for multiple stops on a route. The previous limitation that a dock door is applied only to one stop on a route has been removed. New columns in the Customers table also let you define the Number of Dock Doors and Dock Door Reset Time at customer locations. Transportation Optimization considers these constraints and assigns docks doors on the route for both site and customer stops.

The new Dock Door Assignment output table summarizes dock door use at site and customer locations for each route.

Improved model upload

When you use the upload feature in Modeler , you see the Data Management Upload feature in a new browser tab. This feature provides improved visibility, control, and performance during file uploads. In addition, you can now upload multiple assets at one time and track their progress.

When selecting the file to upload, you can optionally change the name for the uploaded asset.

Data Management displays a progress link above the assets table. Click the link to review all uploads currently in progress. If needed, you can pause the upload and resume at a later time. When resumed, the upload continues from the point where it was paused, rather than requiring a new upload.

Data Visualizations support for Inventory Optimization and Transportation Optimization

When creating a workbook for Data Visualizations, you select the Technology Type to be used. This is one of: Network / Inventory Optimization or Transportation Optimization. The visualizations load script includes the correct tables for the selected Technology Type.

Data Visualizations

Load script enhancements

The Visualizations load script now includes Transportation Optimization tables, allowing users to build visualizations from their Transportation Optimization data model.

The Data Visualizations load script now includes additional templates for you to use to create dashboards. The following templates have been added:

Network and Inventory Optimization templates

• An Inventory Summary Comparison template provides a comparison of inventory costs and policy parameters that can be used to evaluate the performance of the selected scenarios.

• A Customer Demand Report template provides demand by product, customer and class, and allows you to review customer demand time series.

• A Site Demand Report template provides demand by product and site, and allows you to review site demand time series.

• An Inventory Policy Overview template enables you to review recommended inventory policies such as coverage, safety stocks, etc. from different perspectives.

• An Inventory Policy Details template provides an understanding of the calculation of service times. You can apply filters to zoom in for the details of specific sites/products.

Transportation Optimization templates

• A Transportation Summary Comparison template provides an overview of route costs and utilization across different scenarios.

• A Routes Details template reflects the various activities that occur during a route, along with the total distance, cost, drive time and utilization.

• A Shipments Output Dashboard template provides a map of shipments for the selected date range, an overview of shipment status and routed shipments by day.

Landing page enhancements

The Data Visualizations home page grid now allows column filtering and sorting. This will help you find your workbooks.

Support for User Defined Databases (UDDBs)

You can now create Data Visualizations workbooks for your UDDBs on the platform. This includes:

• Creating a new workbook using a UDDB that has been uploaded to the platform

• Adding tables to existing workbooks that use a UDDB as the data asset

• Removing tables to existing workbooks that use a UDDB as the data asset

• When tables are added or removed from the UDDB outside of Data Visualizations, the changes are reflected in your workbook

Supply Chain Home

User Settings

SCDP 40.3.0 Additional email notification option

An option has been added to the Platform category in Email Notifications. The "Database Ready alert" can be used to opt out of email notifications that are generated by database creation in macros, such as solving using a private session.

Email Notifications

Some email notifications from the Supply Chain platform offer an Unsubscribe option. If you want to opt out of receiving notifications for the specific action, click Unsubscribe. The Email Notifications tab in the platform User Settings is opened and the alert is automatically unchecked and saved.

Data Management

Improved asset upload

When you upload an asset or replace an existing asset in Data Management, an improved upload feature is used. This feature provides better visibility, control, and performance during file uploads. In addition, you can now upload multiple assets at one time and track their progress.

Data Management displays a progress link above the assets table. Click the link to review all uploads currently in progress. If needed, you can pause the upload and resume at a later time. When resumed, the upload continues from the point where it was paused, rather than requiring a new upload.

Supply Chain Platform Support

SQL Server 2014 Support

Microsoft will no longer be supporting SQL Server 2014 as of July 9th, 2024. In light of this, llama.ai will no longer allow uploads of SQL Server 2014 starting May 24th, 2024 and will be fully deprecated on July 5th, 2024. Additionally, any existing SQL Server 2014 databases will be migrated to SQL Server 2019 on the deprecation date of July 5th, 2024. This means if you download these databases you will receive them as SQL Server 2019. If this is problematic, you can use our APIs to extract your data. Please contact Coupa Support for questions or assistance.

When uploading databases to llama.ai from the platform, if the SQL Server version is 2014 or earlier, you will be notified that the database will be upgraded to SQL Server 2019. You can either click Upgrade to continue the upload or cancel. When you do upload, the local SQL database is not affected.

If you are uploading a model from Supply Chain Guru X or Data Guru, if the SQL Server version is 2014 or earlier, the database will be uploaded and upgraded to SQL Server 2019 without a notification and confirmation step.

Demand Modeler

Exporting to CSV files

Demand Modeler can sometimes generate large amounts of data. Modelers may want to download this data for internal analysis. When exporting to Microsoft Excel, however, this is limited to less than a million records. For more than a million records, a modeler will now be able to download data using a CSV file.

When data is exported from a specific table from Demand Modeler, the export file type (Excel or CSV) is dependent on the number of records in the table:

• For up to 100,000 records, the data is exported to an Excel file

• For more than 100,000 records, the data is exported to an CSV file.This file type supports exporting up to 5 million records

The export uses any filters applied to the data in view.

The Launch Pad now displays the export process as Data Export.

Prescriptions

Enhancements to Cost Prescriptions

The Cost prescriptions interface has been enhanced to make the results of Cost prescriptions easier to understand at a glance. Changes include:

• The Run Options for Cost Prescriptions now support site groups and product groups. You can use these groups to exclude sites from Node Skipping, set Mode Switch Constraints for sites and products, and set Shipment Frequency Options for sites and products.

• The maps on the Prescriptions’ Detail page now include direction of flow indicators and tooltips to show the flow details.

Updated Node Skipping Detail page

Previously, the “Before Node Skipping was Applied” map and the “Affected Lanes” table included all lane changes for all products. This made it difficult to determine which lane changes affected which products. These visualizations will now display only the lane changes prescribed for the product selected in the Product Insights table.

Enhancements to Risk Prescriptions

The Risk Prescriptions interface has been enhanced to make the results of prescriptions easier to understand at a glance. Changes include:

• On the Network Risk Prescriptions page, new columns have been added to the grid to give the user a better idea of the effects of the prescription. The new columns are:

  • Is Current Top Site-Product?

  • Is Potential Top Site-Product?

  • # of Downstream changes

  • # of Upstream changes

• On the Network Risk Prescriptions page, the “Current Flow Quantity” and “Potential Flow Quantity” columns have been removed. These columns appear on the Prescriptions Detail page.

• On the Prescriptions Detail page, the “Current Network” and “Proposed Network” tables have been merged to create a single summary table for the prescription. This table includes a new “Change Type” column to indicate whether the prescription affects the flow upstream or downstream.

• On the Prescriptions Detail page, the maps now include direction of flow indicators and tooltips to show the flow details.

App Studio

App Studio Tracking

New App Studio Tracking App

The new Tracking app gives Customer Administrators a way to monitor and support the highly customized App Studio solutions that our customers are creating and running within the Supply Chain platform. This app helps diagnose a number of performance, scaling and concurrency issues that are very difficult to diagnose.

The new Tracking app captures and displays metrics for:

• Apps

• App Boards

• Databases and other assets

• Macros

The Tracking app is now available to Customer Administrators on the Supply Chain home page's Administration menu.

Modeler

Platform support for model versions

The Supply Chain platform supports solving models with a database schema of up to 1 year old. As of May 2024 release (R39), this includes models from releases back to the R37 release (schema version 405000). Models with unsupported schemas must be upgraded prior to solving, modeling, using with apps or solving on the cloud. As of R39, support is ending for the following schema version, as well as older model schemas:

• Release R36 (schema 404000)

Direct access to Data Visualizations

You can create visualization workbooks based on data in your Supply Chain models. You can access Data Visualizations directly from your model when it is open in Modeler using the Visualizations icon in the Analysis section of the Navigation pane. If there is already a workbook defined for the model, the workbook is opened in a new browser tab. If there is no workbook defined, you see a flyout where you enter the name for the workbook. When you click Save, the workbook is created and opened in Data Visualizations.

New Allocation Constraint tables

A set of Network Optimization allocation constraints tables were added to the model schema in the previous release. In this release, the tables are available in the user interface and will be used by Network Optimization:

• Flow Allocation Constraints

• Inventory Allocation Constraints

• Production Allocation Constraints

Use these tables to constrain the allocation of flow, inventory, or production. For example, you can define a flow allocation constraint that requires:

The flow quantity through the sites specified by MexicoSites must be at least 40% of the flow quantity through all sites.

In this case you define a set containing the sites in Mexico and evaluate it against a filter column where the value contains all sites. The constraint is defined with a Percentage (the set compared to the filter), a constraint Type (Min, Max, Fixed, Cond_Min, Cond_Fixed) and a Basis (Quantity, Weight, or Volume).

Max Capital Investment option update

The Max Capital Investment option is no longer displayed on the Technology Constraints tab in NO Run Options. You now control this value using the MAX_CAPEX value in the Config_NO table. Enter a positive value and set the Status to “Include” to use the maximum capital investment constraint.

Data Visualizations

Opening models from Data Visualizations home page

You can now open a workbook's associated model in Modeler directly from the Options menu for a workbook on the Data Visualizations home page.

New Data Visualizations tool

Modelers need to create charts, grids, and maps to summarize model inputs, validate baselines, and compare model output across scenarios. The new Data Visualizations tool allows modelers to create dashboards to support key supply chain functions and KPIs that will allow quicker iteration times on model analysis and validation.

This release supports visualization work flows for Network Optimization and Inventory Optimization.

Supply Chain Home Page

User Settings

Updates to User Settings

When you click the user icon on any of the Supply Chain pages, you can select the User Settings option. User Settings provides access to:

• Changing your password

• Generating an API key

• Email notifications

Email Notifications

Many actions in the Supply Chain platform trigger email notifications to be sent. The Email Notifications feature in User Settings allows you to opt in/opt out of some of these notifications. Uncheck any notifications you do not want to receive and click Save to prevent further notifications. You can opt back in at any time. Note: Email notifications that contain links, such as file downloads from the platform and password resets are not available for opt out.

Account activation period extended

The expiration period for the llama.ai account activation URL that is sent via email has been increased to 30 days.

Data Management

Renaming uploaded databases

When uploading a file with the .mdf extension, you can optionally change the name of the uploaded asset. The default asset type will be “Database”, but you can change the type to “Model” if the file is a supply chain model.

Prescriptions

Updated units of measure displayed in dashboards

Supply Chain Prescriptions now displays the appropriate labels for the units of measure that exist in your model (currency, distance, volume, etc). Previously, all labels were set to U.S. dollars, pounds, and miles.

Volume Consolidation improvements

The following improvements have been made to Volume Consolidation prescriptions:

• The Volume Consolidation algorithm has been improved and cost savings should increase.

• The Volume Consolidation algorithm now uses the cost calculator and the basis specified by the user within Volume Consolidation rather than using a “per mile per pound” basis. You can now choose to estimate cost based on units rather than weight. This is useful if the model doesn't have weight information.

App Studio

New App Studio Tracking App

The new Tracking app gives Customer Administrators a way to monitor and support the highly customized App Studio solutions that our customers are creating and running within the Supply Chain platform. This app helps diagnose a number of performance, scaling and concurrency issues that are very difficult to diagnose.

The new Tracking app captures and displays metrics for:

• Apps

• App Boards

• Databases and other assets

• Macros

The Tracking app is available to Customer Administrators by contacting Customer Support.

Macros

New Select Action

The new Select action allows you to choose columns from a single table or multiple joined tables to produce an output record set that can be written to a new or existing table. You can:

• Use Table mapping to define relationships that indicate which records are included (Join types).

• Use a computed field to create an expression that computes a value using fields from one or more tables.

• When using an existing table as the output, use field mapping to map output fields to the existing table structure.

This action enables a simplified workflow compared to using the existing Create Table and Insert actions:

• You do not need to specifically know or define the structure of the table first.

• The table does not need to exist before the “insert” part can be constructed.

• The table is dropped when refilled, so it doesn’t matter if there is an older definition of it currently in existence.

This new action does not replace the Create Table or Insert actions.

This function is the Macros analogue of the Select Transform in Data Guru. The Select Transform action in Data Guru performs the functions of both Select and Insert actions in the same transform: using an existing table or creating a new table is selected via a radio button.

New Update Table Action

The new Update Table action updates existing rows in a single table. It also allows you to add new columns to the table before updating, but not to add new rows.

This is different from the existing Update Action, which allows updating of existing columns in multiple tables, as well as assigning values to parameter values.

The new action simplifies the workflow compared to using the existing Add Column action and Update action:

• There is only one table involved.

• Columns do not need to exist in the table in order for the update to be built. You can add new columns to the table and then update them in a single action.

• There are no ordering considerations.

This is the Macros analogue of the Update Transform in Data Guru.

Modeler

Platform support for model versions

The Supply Chain platform supports solving models with a database schema of up to 1 year old. As of January 2024 release (R38), this includes models from releases back to the R36 release (schema version 404000). Models with unsupported schemas must be upgraded prior to solving, modeling, using with apps or solving on the cloud. As of R38, support is ending for the following schema versions, as well as older model schemas:

• Release R34 (schema 402000)

• Release R35 (schema 403000)

Driver Scheduling duty duration

The driver Duty Duration has been added to the Driver Summary output table for Transportation Optimization.

Improved cost allocation in shipment output tables

Shipment output tables now define both Distance-Based Allocated Cost and Time-Based Allocated Cost. The new Time-Based Allocated Cost enables you to account for excessively long load and unload times. This uses the product of the shipment’s quantity and the travel time on the route combined with load and unload times. These values are in the Shipment Output and Delivered Shipments output tables for Transportation Optimization.

Start and end of route service time input for Transportation Assets

You can define specific service times that apply to the start and end of each route. These service times can account for pre- and post-route activities such as documentation and vehicle refueling. Use the Start Of Route Service Time and End Of Route Service Time columns in Transportation Assets to define the time for these activities.

Duplicate constraint names excluded from Network Optimization input files

If you defined multiple constraints in a table with the same name, duplicate constraint names were being written to input files. In this case, Network Optimization uses the last constraint record written to the input file and ignores all duplicates. This behavior has been changed so that in the case of duplicate constraint names, only the first record is written to the input file. The duplicates are reported in the ErrorLog.txt file

Spatial constraint costs in Cost To Serve

Expansion costs, the Fixed Operating Space Expansion Cost from Sites and the Floor Expansion Cost from Site Storage Spaces and Site Shipping Spaces, are currently included in Other Cost in Cost To Serve Details. The Site Variable Cost from Sites is currently included in the Total Cost value.

Supply Chain Home Page

Data Management

Control over column width

You can now adjust the widths of columns in the Data Management grid. This is helpful when distinguishing assets that have similar lengthy names. When you leave and return to the Data Management page, the default column widths are applied.

Asset size values in Data Management

Data Management now provides information about the physical size of assets. In the grid, there is a Size column. The Size column value can be refreshed at any time by selecting Refresh Asset Size from the kebab menu for a given asset. When viewing the Details of a selected asset, you see the last calculated size and the date when this value was refreshed. Keep in mind that when downloading an asset, the actual size of the downloaded file is likely to be smaller than the value reported in Data Management.

SQL Server version information for assets in Data Management

When you view the Details for a selected asset, the SQL Server version is displayed in the top section of the flyout.

CSV export from database and DDM tables

You can export up to 10,000 records from tables in user defined databases and DDMs to a .csv format file. When you view a database or DDM in Data Management and select a table, the Export option is available in the header for the table.

Prescriptions

Network Risk prescriptions added

In addition to the complexity of supply chains, they inherently involve risk. Recent years have highlighted that risk, as companies have struggled to overcome a variety of challenges to their supply chains. Single- and multi-point failures can lead to major disruptions of the supply chain, impacting corporate revenue and reputation. Modelers need to quantify and model risk in their supply chains as they work to make their supply chains more resilient and cost effective.

With the new Supply Chain Prescriptions Risk feature, you can mitigate the effects of potential single point failures that can lead to disruption of the supply chain network. The Risk app identifies sites and lanes that are critical from a revenue or value of goods flown perspective, and then generates constraints that must be imposed on the network to minimize the risk of those critical sites and lanes. The constraints correspond to various levels of risk. There are four types of prescriptions for Risk:

• Alternate supplier sites

• Alternate manufacturer sites

• Alternate distribution centers

• Flow shifts

These prescriptions can be reviewed by supply chain managers, who can accept or reject the prescriptions.

App Studio

Document Grid Menu

A new right-click menu has been added to the column header on grid widgets in the Layout Designer and Application Viewer. Sorting, Fixing, Conditional Formatting, Clearing and Calculated Columns modification can now be applied to grids.

Macros

Import and Export Macros

The ability to Import and Export a macro has been added. Now, you can easily export a macro or a packaged folder of macros to share with others and import macros into your project to view and modify them.

Drop Table Logic Action

The ability to Drop a table from a macro has been added. Now, you can easily remove a table at the end of a macro run.

Modeler

Platform support for model versions

The Supply Chain platform supports solving models with a database schema of up to 1 year old. As of September 2023 release (R37), this includes models from releases back to the R34 release (schema version 402000). Models with unsupported schemas must be upgraded prior to solving, modeling, using with apps or solving on the cloud. As of R37, support is ending for the following schema version, as well as older model schemas:

• Release R33 (schema 401000)

Technology display mode

The Technologies tab in Model Settings provides you with a way to limit the input and output information displayed based on the solver technology (or technologies) you use. For example, if you are currently working on a model for use with Network Optimization only, you do not need to see the tables and columns that are used only by Transportation Optimization, such as Rates and the Service Time columns on Sites. Turn on only the Network Optimization switch to hide information that applies to Inventory Optimization, Transportation Optimization and Simulation.

In addition, you can use the Basic mode to further limit the displayed tables and columns to only those required and most typically used when modeling.

See Technologies model options.

Early/late demand updates

The Customer Order Fulfillment table is no longer read-only. The Fulfillment ID,Single Source Fulfillment and Single Period Fulfillment columns in Customer Demand and Customer Orders are also no longer read-only. The Fulfillment ID column in both the Customer Demand and Customer Orders tables uses values defined in the Fulfillment ID column in the Customer Order Fulfillment table.

Updates to Sequential Objectives

A number of new Objective values are available in the Sequential Objectives input table:

Penalty Cost	Customer Revenue	Fractional Return Destination Constraints
Total Closing Cost	Site Demand	Return Flow Balance Constraints
Total Duty Cost	Inventory Process	Return Process
Total Expression Based Cost	Maximum Number of Transportation Asset	Single Return Destination Constraints
Total Fixed Startup Cost	Batch Flow	Sourcing Process
Total Inbound Warehousing Cost	Production Process	Process BOM Connection
Total Outbound Warehousing Cost	Fractional Process Constraints	Process To Process Relation
Total InTransit InvCost	Single Process	Transportation Process
Total TPAsset Cost	Process Step Balance Constraints
Total Work Resource Cost	Single Process Step

Several Objective values have been removed, as they are not used by the Network Optimization solver:

• Make Processes Single Sourcing

• Make Processes Fractional Sourcing

• Make Process Flow Single Destination

• Make Process Flow Fractional Destination

If your Sequential Objectives table includes any of the objective values that have been removed, you will see a warning in the ErrorLog.txt when you run the model. However, this is expected since the solver does not use them.

Control over Cost To Serve internal table population

When you run Network Optimization, a number of internal tables are populated with data that is used by Cost To Serve Analysis. These tables can have significantly large numbers of records. You can use the new SKIP_COST_ALLOCATION_OUTPUT parameter in the Config_NO table to prevent these tables from being populated if you do not plan to use Cost To Serve Analysis. Make sure the Parameter Value is 1 and the Status is "Include" to enable this behavior.

Shipment-based rates

Transportation Optimization supports Per Unit Cost and Discount Rate values at the route level, where each shipment on the route is assigned the same cost and rate. You can use shipment-based rates where different costs and rates are allowed for each shipment on a route. This functionality enables you to define route costing and rating with increased granularity. It also provides a way to model LTL aggregation, where shipments with different LTL rates can be combined on a single route. First you assign a classification (Class Name) to the shipments, then create Per Unit Cost and Discount Rate values for each unique asset-source-destination-class combination in the Shipment-Based Rate table.

See Shipment-based rate.

Drone modeling updates

You can now constrain the maximum time that a drone waits at a location. Also, the Sortie ID has been added to the Shipment Output and Delivered Shipments output tables.

Driver scheduling updates

Additional columns have been added to let you constrain the Driver Scheduling problem type to adhere to regional driver requirements, such as US DOT regulations. You define the drive time for routes that are the source for Driver Scheduling. You can then constrain the maximum drive time that can be incurred per shift for a driver class.

Supply Chain API

Endpoints removed for Insights

All endpoints for the Insights product have been removed from the Supply Chain API.

New endpoints

• GET /v4/dataset/{datasetId}/collection/{collection}/record/pointer

  Returns data from a dataset collection, given the dataset ID and the collection name. Pass paging size and the index key with the request to retrieve data from any key of the collection.

• GET /v4/model/{modelId}/table/{tableName}/record/pointer

  Returns data from a table in a model by the model ID. Pass paging size and index key with the request to retrieve data from any key of the table.

For more information on using the Supply Chain API, see the Supply Chain API Portal at https://developer.llama.ai.

App Studio and Macros

Addition of CountZ and CountAllZ functions

The CountZ and CountAllZ functions have been added to the system. The CountZ and CountAllZ functions are the similar to the Count and CountAll functions, except that nulls are treated as zero.

Statement Editor update

For auto incremented columns and computed columns, the Statement Editor is unavailable. These types of columns are computed automatically by the system.

Macros

Using the Snap Grid

A new Snap Grid button has been added to the design surface to enable you to show or hide a grid on the design surface. Now, you can easily snap a grid to the design surface.

Using the Zoom Slider

A new Zoom Level Slider has been added to the design surface to enable you to easily zoom in and out of the design surface. Now, you can quickly zoom in and out to better navigate the design surface.

Copy and paste a macro action

The ability to copy a macro action has been added while working on the macro. This will save time if you need to insert similar actions into another macro with small changes for each action.

Excel Import action update

The ability to specify that all empty cells are treated as null or default empty values has been added to Excel Import Action.

Prescriptions

SCDP 36.3.0 Change to Node Skipping

Node Skipping prescriptions will now match “Source”, “Destination” and “Product” for a lane rather than just matching “Source” and “Destination”. If a lane matches the Source, Destination, and Product values of any flow constraint in Modeler, Prescriptions will “exclude” that flow constraint and include the prescription.

Change to the Web address for Supply Chain Prescriptions

The Web address for Supply Chain Prescriptions has been changed to us.llama.ai/prescriptions for U.S. customers and eu.llama.ai/prescriptions for E.U. customers.

Accepting and rejecting prescriptions (Prescriptions Lifecycle Management)

Users will now be able to accept or reject prescriptions according to the operational feasibility in their supply chains. This allows the Prescriptions engine to learn from the user what prescriptions are feasible or infeasible, and to generate more business-relevant prescriptions. The user can then spend less time reviewing prescriptions that are not relevant to their business.

The Supply Chain Prescriptions user will be able to:

• Accept a prescription or a group of prescriptions

• Reject prescriptions in bulk due to quantity, potential savings, volume, and weight

• Access an archive that shows a list of criteria on which prescriptions were previously rejected

Updated Prescriptions Summary page

The Prescriptions Summary page has been enhanced to provide more information at a glance.

The Summary header now includes:

• The total number of prescriptions

• The total number of accepted prescriptions (once prescriptions have been accepted )

• The total accepted savings (once prescriptions have been accepted )

• A tooltip that describes the savings, including a summary of the number of prescriptions that have been accepted in the current run

The Summary page also now includes these enhancements:

• The Potential Savings by Prescription Type and Insights on Potential Savings charts are next to each other for easier viewing

• The Top Factors Increasing and Decreasing bar chart is now color coded by increasing and decreasing costs and the chart has been moved above the Top 10 Prescriptions grid

• The fixed bar chart labels are now available as tool tips. Hover over a chart bar to see the precise value for that bar

• The charts have been updated to include horizontal grid lines to make the charts easier to read

• The Summary page now appears when a run is completed so that the user can quickly see results.

Updated Prescriptive Insights pages

The Prescriptive Insights pages have been restructured to provide more information at a glance. These pages will now display the Prescriptions grid automatically. You can view the details for a prescription by clicking the prescription’s ID link.

For the Mode Switching and Volume Consolidation pages, you can view the Overview tab for the prescription type by clicking the Overview tab at the top of the page.

New “All Prescriptions” page

The “Export to Model” page has been renamed to “All Prescriptions”, and the prescriptions grid has been updated to include more information about each prescription. In particular, the grid now includes two new columns:

• The new Status column indicates if the prescription has been accepted, rejected, or not yet reviewed.

• The new Exported column indicates if the prescription has been exported to Modeler.

Prescriptions export enhancements

The Prescriptions export processes have been changed to only export prescriptions with a status of “Accepted” or “Unreviewed”.

Searching for projects and models

On the Prescriptions home page, the Search field can be used to search for a specific model as well as a project.

Demand Modeler

SCDP 36.1.0 New parameters

The following advanced scenario parameters have been added:

• Batch Size: Specifies the max number of historical feature matrix records to pass to each concurrent execution of the feature selection method.

• Feature Report Filter Selected Features: Specifies whether or not to show only features selected for inclusion in an LOD’s local models in the Feature Report.

• Enable New Product Introduction?: Specifies whether or not to generate forecasts for LODs that have insufficient history to be forecasted with local algorithms.

• Ensembler Weights: A dictionary specifying how much weight to assign to each estimator in the ensembler (if the Forecast Strategy main parameter is set to “Ensemble”). If left blank, all estimators receive equal weight.

• Imputation Strategy: Specifies the method to use to impute mapped features and trend cloud features. Supported options are: Backward Fill, Fill NA Value, Forward Fill, Lag, Moving Average.

• Imputation Value: Specifies the value to pass along with the Imputation Strategy when the strategy is Fill NA Value, Lag, or Moving Average.

• Fold Overlap Size: Specifies the number of historical periods to share between one backtesting fold and the next.

• Overlap Unbiased Fold: Specifies whether the Fold Overlap Size (when greater than 0) applies to unbiased test folds in addition to estimator selection folds.

• Seasonal Cycle Detection Method: The method to use to detect seasonal cycle frequencies when Best Seasonal Cycles is None. Supported options are: PyCaret, ACF, FFT. PyCaret is used when this parameter is blank.

A new Trend Cloud option has been added: 

• Enhanced Logging: Specifies whether or not detailed logging will be conducted during the Pull Trend Cloud action

SCDP 36.1.0 New filter behavior based on the Level of Detail parameter

The filters for the three main dimensions on the Output Overview pages now behave a little differently. The option ALL is available only when dimensions are not selected in the Level of Detail parameter on the scenario's Advanced Parameters tab.

 

Modeler

SCDP 36.1.0 Validation for user defined columns

Input table validation has been extended to user defined text columns that are defined with a specific Usage, such as "Customers" and "Status". This feature applies to user defined columns in standard tables and in user defined tables.

Platform support for model versions

The Supply Chain platform supports models with a database schema of up to 1 year old. As of release 36.0.0, this includes models from releases back to the R34 release (schema version 402000). Models with unsupported schemas must be upgraded prior to solving, modeling, using with apps or solving on the cloud. Support is ending for the following schema versions:

• Release R30 (schema 303007)

• Release R31 (schema 303009)

• Release R32 (schema 400000)

• Release R33 (schema 401000)

According to our standard support policy, we plan to retire Design Engines that are 1 year old or older. In an effort to provide advance notice, as part of the R37 release (planned for September 2023), we will be shutting down the R34 Design Engines.

Control over data formats in tables

Date, numeric, and currency values in tables can be difficult to read if not in a format that is typical for the user. The Data Formats tab in Model Options provides options that let you control the format for each of these types of values. For numeric and currency values, you set the number of decimal places, how negative values should be displayed and whether to include the thousands separator. Currencies also support options that let you select the position of the currency symbol, or hide the symbol. Dates offer short and long date and time formats, and an option to exclude the time component.

User defined tables and columns

You can create new user defined input tables that can, for example, serve as inputs to solver customizations or as data sources for input pipes. These tables are maintained when models are upgraded for new product releases.

User defined columns let you add columns to existing input tables or to user defined tables. You can use these columns for filtering tables and for storing additional information not covered by standard columns. You specify the data type for each column: text, integer, decimal or date. For the text columns, you can optionally specify a usage such as "Customers" or "Products". When a usage has been applied, the record names, groups names and filter names defined for the usage will be available in the dropdown list for the user defined column value. This behavior is similar to what is available in the Customer column in the Customer Demand input table. User defined columns can be deleted as needed.

Appending records with table import

When using the Import feature to import records into a Modeler input table, you now have the choice of whether to replace all existing records or append the imported records to those already in the table. When appending, if any of the records from the source result in records that would violate duplicate entries in the table, the import will fail.

Early and late demand modeling

Early and late demand modeling allows you to specify demand records that can be served outside the demanded period. You can associate penalty costs for early/late fulfillment as well as limits on demand timing. You can prioritize demand, allowing models to be broken down to reduce overall complexity.

New columns in the Customer Demand and Customer Orders table let you define the demand timing and associated penalties. In Customer Demand, use Periods Allowed Early and Periods Allowed Late and the corresponding delivery penalty cost columns. Similarly, in Customer Orders, use Time Allowed Early and Time Allowed Late and the corresponding delivery penalty cost columns.

Columns have been added in a number of Network Optimization output tables, providing details about early and late demand fulfillment, including penalty costs. This information is available in Network Summary, Financial Summary, Network Organization Summary, Network Customer Summary, Network Product Summary and Customer Demand Summary.

See Demand timing.

Model decomposition

The decomposition method allows you to break a large model into smaller pieces and solve them more efficiently. For large models, this method can help reduce both solving time and memory usage significantly. Model decomposition extracts solvable sub-models from the original model by analyzing the complex relationship across all supply chain elements: products, sites, lanes, demand, bills of material, work centers, processes and constraints. In this release, the main focus is on the constraints related to products, so each sub-model will have a different subset of the products. Each sub-model contains only its own data which makes the problem size much smaller. After solving all the sub-models, the solution of the original model is obtained by merging the output of all the sub-models.

See Decomposition.

Sequential objectives

Objectives have been updated in the Sequential Objectives table:

• "Total CO2 Emission" has been renamed to "Total CO2 Cost" to reflect the fact that this objective is based on the cost associated with CO2.

• "Total CO2" has been added. This objective is based on the weight of carbon emissions.

• "Carbon Footprint" has been renamed to "Maximum Carbon Footprint" since this is based on Maximum Carbon Footprint in the Greenhouse Gases table.

Predicted solve time

When running Network Optimization models, it can be hard to know the complexity of the problem and how long it will take to solve. The solve process includes an improved method to both identify a solve time range and highlight complexities in the model that may contribute to longer solve times. This information can help you understand what drives model complexity and how this affects solve times. The predictive information is displayed in several places:

• The Scenario Status Queue on the Modeler landing page

• The Scenario Queue on the Modeler Launch Pad

• The General tab for a Queue Management Models

• The solve log that is available in Queue Management

Drone modeling

Transportation Optimization includes the capability to model drones with ground transportation assets, enabling users to deploy drones that make deliveries in coordination with trucks. The trucks serve both as a mobile depot, where drone launches and retrievals are performed, and a delivery asset. Transportation Optimization determines where and how to incorporate drones into the logistics operations to improve last-mile delivery and reduce cost.

Drone truck delivery supports a number of features, including:

• Define various drone types by payload, speed and battery

• Assign drone types to ground vehicles as potential companions in performing delivery

• Allow for fixed and linear endurance models to determine the effective flight range

• Overwrite point to point flight distance and time with transit matrix

See Modeling drones.

Driver scheduling enhancements

New inputs have been added to improve control over the Driver Scheduling problem type in Transportation Optimization:

• Driver Availability - Use this new input table to define the number of drivers per driver class available at a site. You can also constrain the time window for which the driver class is available.

• Routes - The Asset Origin column has been added to this input table to identify where the transportation assets originate for driver scheduling. This value is now populated in a number of output tables when the model is solved.

A new Driver Utilization output table provides a summary of drivers available and used per site - driver class combination.

Closing Cost data type change

The data type for the Fixed Closing Cost column in the Sites, Sites Multi-Period, Work Centers, and Work Centers Multi-Period tables has been changed from float to text. This change is to support the use of currencies when defining the closing cost.

Map performance improvements

Map display performance has been updated to use batched requests. This helps to prevent the display of the map layer and associated table grid from timing out with large numbers of records.

Updated default value for Post Process Random Lead Time

The default for the Post Process Random Lead Time option on the Safety Stock Optimization Advanced tab in Inventory Optimization options has been changed from unchecked (off) to checked (on). This applies to new models and existing models where you have never set the option. If you have manually set the option, the value will not be changed during model upgrade. Most IO models have lead time variation, so it is typically expected that the option should be selected. This change ensures that you actively turn it off if not needed.

Tables handled during NO-IO Conversion

NO-IO Conversion handles the following tables during the model transformation:

Products, Sites, Customers, Periods, Modes, Bills of Material, Bill of Material Assignments, Customer Orders, Customer Demand, User Defined Customer Forecast Profile, User Defined Site Forecast Profile, Production Policies, Inventory Policies, Site Sourcing Policies, Customer Sourcing Policies, Transportation Policies, Transit Matrix, Group Members, Options.

For this release, tables were added in addition to those handled in the previous release. These specific tables are:

• User Defined Customer Forecast Profile

• User Defined Site Forecast Profile

• Transit Matrix

The actual Groups are not copied into the destination model. Group members are used when interpreting the NO output. Options is an internal table that stores model and solver run options.

Multi-period models are treated as single period models after conversion to prevent all demand from being "extremely slow". While Periods are handled during conversion, multi-period tables, such as Sites Multi-Period, are not brought into the new model.

Getting Started page updates

Links on the Modeler Getting Started page have been updated to correctly reflect the locations for Coupa University and the Coupa Support Portal.

Home page features

Model Building

Run recipe flyout update

The recipe name has been added to the Run Recipe flyout indicating which recipe is to be run

Data Management

Upload Data for Decision Data Models

Data Management now includes the ability to upload CSV files to DDMs in the Data Viewer.

Database Extension for Decision Data Models

Decision Data Models can now be expanded to include additional tables and columns. Adding columns to existing tables allows you to customize your DDM to include additional metadata which is not already available in the DDM structure. Adding tables to your DDM provides additional content for use within the SCDP platform (for example, adding lookup tables for macros). Extension columns are supported across the platform.

Preview During Dynamic View Creation

A new Preview tab will be added to the Dynamic View editor to enable you to quickly see the results of your dynamic views. This will help you validate that you have set up a view correctly. Previously, you had to create an App Studio app board for every view you wanted to preview, which required access to App Studio.

Duplicating Dynamic Views

You will now be able to duplicate an existing dynamic view. You can then use this duplicated view as a starting point for a new view.

Macros

Using the Snap Grid

A new Snap Grid button has been added to the design surface to enable you to show or hide a grid on the design surface. Now, you can easily snap a grid to the design surface.

Using the Zoom Slider

A new Zoom Level Slider has been added to the design surface to enable you to easily zoom in and out of the design surface. Now, you can quickly zoom in and out to better navigate the design surface.

Copy and Paste a Macro Action

The ability to copy a macro action has been added while working on the macro. This will save time if you need to insert similar actions into another macro with small changes for each action.

Addition of CountZ and CountAllZ Functions

The CountZ and CountAllZ functions have been added to the system. The CountZ and CountAllZ functions are the similar to the Count and CountAll functions, except that nulls are treated as zero.

Statement Editor Update

For auto incremented columns and computed columns, the Statement Editor is unavailable. These types of columns are computed automatically by the system.

Excel Import Action Update

The ability to specify that all empty cells are treated as null or default empty values has been added to Excel Import Action.

Queue Management

Auto refresh

A checkbox has been added to Queue Management that lets you enable an auto refresh of the grid contents. When enabled, the grid refreshes every few seconds.

Paging controls

Queue Management supports controls that let you set the page size of the grid and navigate to a specific page.

Refresh logs

A Refresh Logs button has been added to the Logs tab in Queue Management. Use this button when a queue item is running to display the latest log information.

Supply Chain API

New endpoints

• GET /v4/dataset/{datasetId}/collection/{collection}/record/pointer

  Returns data from a dataset collection, given the dataset ID and the collection name. Pass paging size and the index key with the request to retrieve data from any key of the collection.

• GET /v4/model/{modelId}/table/{tableName}/record/pointer

  Returns data from a table in a model by the model ID. Pass paging size and index key with the request to retrieve data from any key of the table.