1. Selection Builder
The Selection Builder introduces a visual, no-code interface within the Architect Selection tab that makes it easier to filter data, build conditional statements, and group results — all without writing queries manually. Users can now interact with their data in a more intuitive, guided way.
What's New
1. Visual Filter Builder
Users can now apply filters directly on any table within Architect. For example, when working with the Sites table, a user can narrow results down to a specific city or region by selecting filter conditions through a simple point-and-click interface — no query language required.
How to use it:
1. Navigate to the Selection tab in Architect
2. Click the + New button in the top-right corner.
3. Select the table you want to work with
4. Click Add Filter and choose your column, condition, and value
5. The preview instantly reflects your filtered view
2. Selection Builder
Building complex data conditions is now more approachable. Users can construct multi-step statements row by row, selecting the table and column at each step and combining conditions in a structured, readable layout. This replaces the need to manually write or interpret logic expressions. Users can now group Conditions and use AND and OR operators to create complex filters.
How to use it:
1. Within the Selection tab, open the Selection Builder
2. Choose a table and column for each condition row
3. Set the operator and value, then add additional rows as needed
4. Rows are displayed in a clean, sequential format for easy review and editing
2. Update Builder
SCA V3 introduces the Update Builder, a powerful new tool that allows users to create and apply custom data updates directly within the platform—without writing code. Users can now define update rules using a guided interface, combining column selections and values to modify data efficiently and accurately.
What's New
Each update requires three fields: Update Name, Select Column, and a value or expression input.
The value field supports numerical values, text, math operators, logical operators, and column references—or combinations of all four.
A SQL preview mode is available to review the generated query before saving.
How to use it:
Follow these steps to create a new update:
1. Navigate to the Updates page.
2. Click the + New button in the top-right corner.
3. Select + Add to begin defining the update.
4. Enter a name in the Update Name field.
5. Click the Select Column field and choose a table and column from the dropdown.
6. Enter the desired value in the third field. Supported input types:
• Numerical value (e.g., 100)
• Text — must be wrapped in single quotes (e.g., 'Active')
• Math operator combined with a column or number (e.g., column + 10)
• Logical operator (e.g., combined condition expressions)
• A combination of text, operators, columns, and numbers
7. Optionally, click SQL to preview the generated query and confirm it is correct.
8. Click Save in the top-right corner to save the update.
3. Base Scenario Builder
The Base Scenario Builder for Network Optimization is a new guided, step-by-step interface within Architect that enables users to create a base scenario without needing deep knowledge of the underlying data model. Instead of manually configuring tables, users are walked through a structured process — from defining model parameters to entering customers, sites, products, demand, and periods — with built-in validation, geocoding, and data import support throughout.
What's New
With this release, users have access to a structured builder that guides them through each step in the correct order, validates entries in real time, and surfaces only what's needed at each stage.
Guided Step-by-Step Builder The builder walks users through scenario creation in a logical sequence, separating "Key Tables" from "Main Tables" to reduce complexity. Each step includes contextual explanations, field-level descriptions accessible via hover, and validation to prevent common entry errors.
The steps are:
Model Setup — Users will define the name of the Base Scenario and whether the model is single- or multi-period
Key Tables — Users will build the next tables: Customers, Sites, Products, Periods and Customer Demand.
Product Creation — Users will build the next tables: BOMs, Processes and SiteProcesses.
Inventory/Distribution — Users will build the SiteProducts table.
Transportation Tables — Users will build the next tables: Mode, CustomerLanes and IntersiteLanes.
Constraint Tables — Users will build the next tables: UserConstraints and UserConstrintComponents.
Built in Data Validation. Each table automatically validates entries for data type and allowable solver values (Yes / No / FRC). All newly added rows default to “Yes” for solver inclusion.
Flexible Data Entry. Users can import and export CSV files for any individual table. Rows can be added or deleted easily, and a “Show Required Fields Only” toggle helps streamline the experience during initial setup.
Geocoding Support. Applicable tables include a one click geocoding action that automatically populates latitude and longitude for a single row or multiple rows at once.
Existing Scenario Support. Users can create a scenario from scratch or start from an existing base scenario. When resuming from an existing scenario, previously defined data is preserved and editable.
Confirmation and Scenario Card. After completion, users see a confirmation screen indicating the builder finished successfully. The newly created scenario appears immediately as a card in the Base Scenario tab.
Mode Helper. Provides guidance for defining transportation costs based on multiple units, such as distance, shipment size, or other configurable cost drivers.
Bulk Updates. Allows users to populate or update values across multiple records simultaneously, reducing manual data entry.
How to use it:
1. Navigate to the Architect module.
2. Click the Base Scenario tab.
3. Select Build in Architect to launch the builder.
4. Follow the on-screen steps to complete your scenario configuration.
4. Tariff Integration
Architect now supports tariff-aware network design analysis, giving users the ability to factor in import tariff data when evaluating supply chain scenarios. This initial release establishes the foundation for cost-informed decision-making directly within the platform.
What's New
Tariff Data Integration Users can now incorporate tariff information into network design analysis. Tariff data includes HTC codes, origin and destination pairings, and applicable tariff rates — the key inputs needed to assess landed cost impact across a network.
New fields:
One new field has been added to the Products
HTCCode (Harmonized Tariff Code) codes are now associated at the product level in the Products table, ensuring the correct tariff classification is applied automatically when running analyses.
Four new fields have been added to the IntersiteLanes (and CustomerLanes) tables to support tariff tracking:
UseTariffRates — Set to Yes on lanes where a product is being imported into the US to trigger automatic tariff calculation. All other lanes can remain NULL or No. . This gives you precise control over which lanes factor tariff data into your analysis.
TariffRate — The tariff rate applied against the Product Value defined in SiteProducts. Auto-populated by the Apply Tariffs feature; leave blank unless entering manually.
TariffEffectiveDate — The date the tariff takes effect. Auto-populated; leave blank unless entering manually.
TariffNotes — Indicates the source of the tariff rate, or flags cases where a rate could not be found. Auto-populated; leave blank unless entering manually.
New Functionality: Apply Tariffs
A new Apply Tariffs button is available on each Base Scenario card in the Base Scenarios page. This workflow allows users to automatically calculate and populate tariff data on applicable lanes.
How to Use:
Add the HTSCode (8-digit code) to the relevant Product record in the Products table.
Identify the import lane — either in IntersiteLanes (site-to-site) or CustomerLanes (site-to-customer) — where the out-of-country product enters the US.
Set UseTariffRates to Yes on that lane record.
Navigate to the Base Scenarios page and click Apply Tariffs on the relevant scenario card.
Select the applicable lanes table and an Overwrite Rule, then click Apply Tariffs.
The system will auto-populate TariffRate, TariffEffectiveDate, and TariffNotes using the HTSCode and the origin site's country.
Notes
If a rate cannot be found, the TariffNotes field will indicate this.
Manual overrides are supported by populating TariffRate, TariffEffectiveDate, and TariffNotes directly.
HTC code assignment to products is a manual step; automatic derivation of HTC codes from product descriptions is not supported in this release.
5. Intermediate Solutions
Intermediate Solutions enables users to capture, view, and analyze optimization solutions found during the solving process—not just the final result (Only applicable for Network Optimization). This capability provides visibility into solution progress and allows users to create scenarios from any intermediate solution discovered during optimization, giving greater flexibility to explore alternative outcomes. This is one way to automate sensitivity analysis by comparing multiple solutions generated during a single optimization run.
What's New
Enhanced Solution Visibility
Users now have multiple ways to monitor optimization progress in real-time:
Solver Metrics Table: A periodically updated summary showing solution count, best bound, gap, and best solution value throughout the solve process
Solver Solution Progress Chart: A graphical representation displaying:
Best solution found (orange line, left axis)
Best bound (blue line, left axis)
Gap between best solution and best bound (green area, right axis)
Create Scenarios from Intermediate Solutions
Users can now generate full scenarios from any solution discovered during optimization:
Click the "Create Scenario" button next to any intermediate solution in the solver metrics table
The system automatically:
Creates a new scenario card in the UI
Copies all solution table data for the selected solution
Runs post-processing and generates complete reporting
Makes the intermediate solution available for analysis like any other scenario
How It Works
During Optimization:
The solver automatically captures solution data at regular intervals as new solutions are found
Intermediate solutions are stored in timestamped tables (TS tables) with minimal overhead
Each solution is indexed by solution number for easy reference
Creating Scenarios:
Select any intermediate solution from the solver metrics table
The new scenario contains a complete copy of the original scenario definition plus the selected solution data
All standard reporting and analysis tools work with scenarios created from intermediate solutions
Notes
Who This Affects
All users: Benefit from improved visibility into optimization progress
Power users: Can leverage intermediate solutions for sensitivity analysis and exploring alternative outcomes
Users with long-running models: Can monitor progress and capture promising solutions before optimization completes
Scenario Behavior
Scenarios created from intermediate solutions are independent copies of the original scenario
Re-running a scenario created from an intermediate solution will solve from scratch—it will not force the same solution
Nothing in the scenario definition preserves which intermediate solution was used
Database Space Considerations
Intermediate solution data is stored automatically for all optimization runs
The TS tables store minimal information during solving with low space impact
Creating full scenarios from intermediate solutions generates standard solution and reporting tables
Performance Guidance
For most use cases, default settings will perform well. Users with very large models generating many intermediate solutions should contact the development team if performance issues arise—backend configurations can be adjusted to limit the number of solutions captured.
How to Use:
1. Go to the Scenario card and click Execute All Scenario Steps.
2. Once the scenario enters the solve process, click View Output.
3. Click on the Solve tab. Here the user can view the following:
Solution Progress
Solver Metrics
Intermediate Solutions
Log
Settings
4. Click on the Intermediate Solutions tab to view the intermediate solution list.
5. From this view, the user can select one or more intermediate solutions using the checkboxes. Once selected, the Compare button becomes available to display a side-by-side comparison of the selected intermediate solutions (high-level KPIs).
6. The user can also select an individual intermediate solution and create a scenario from it to explore all populated output tables in detail. To do this: select the intermediate solution and click on +Create Scenario from Solution
7. Navigate away from the screen so that the newly created scenario populates in the Scenario list.
Bugs Fixed
Fixed an issue where the Period table was not copied when duplicating a scenario.
Fixed an issue where not all scenario settings were copied during scenario duplication.
Additional Enhancements
Added a Base Scenario filter to the Query View for sol and rpt tables.
Expanded the Map View to utilize the full screen.
Added a toast notification to indicate when distance calculations are in progress.
Improved the Action creation workflow: when users create a new Selection or Update while defining a new Action, the newly created Selection and/or Update is now automatically populated in the Action. This removes the need to manually search for and toggle them after creation, streamlining the process and reducing unnecessary steps.