Importing ASIS Data

TIP

ASIS import lets you load your current (as-is) supply chain as result data, so you can compare it directly against optimized results. Network optimization takes transportation flows; inventory optimization takes held safety stock.

What Is ASIS Import?

ASIS import registers what you do today as results against a scenario that already has its input data imported. This lets you see the as-is picture alongside the optimized one, side by side, on the same screens.

Module	What you upload	Where to compare
Network optimization	Actual transportation flows and open facilities	Analytics, Maps
Inventory optimization	Safety stock held per location × product	Comparison, Analysis, Results

The rest of this page covers network optimization. See Inventory optimization ASIS import for the inventory side.

Prerequisites

The target scenario must have data already imported via the standard import before you can use ASIS import. If location, product, and transportation mode master data are not registered, the import will fail.

See Getting Started for the standard import steps, and Excel File Format for the expected file structure.

Sample file	Purpose
example-import.xlsx	Standard import sample — use this first to set up master data
example-asis-import.xlsx	ASIS import sample — use this after the standard import is done

Import Steps

1. Open the Data tab.
2. Click Upload ASIS data in the left-hand menu.
3. Click CHOOSE FILE, select your ASIS flow Excel file, then click Import.

TIP

Download the sample ASIS Excel file to use as a starting point.

Excel File Format

The ASIS import file must contain two sheets: Flows and Opened Facilities. In both sheets, row 1 is treated as the header and data begins from row 2.

Flows Sheet

Column	Type	Values	Required	Description
From	String	-	Required	Origin location name (must match a registered Locations.name)
To	String	-	Required	Destination location name (must match a registered Locations.name)
Product	String	-	Required	Product name (must match a registered Products.name)
Mode	String	-	Required	Transportation mode name (must match a registered Transportation Modes.name)
Flow	Float	-	Required	Flow quantity (must be 0 or greater)
Flow Unit	ProductUnit	pcs	Required	Unit for the flow quantity

Opened Facilities Sheet

Column	Type	Values	Required	Description
Facility	String	-	Required	Facility name that is open in the ASIS network (must match a registered Facilities.name)

Validation Rules

• From, To, Product, and Mode must all match master data already registered in the target scenario.
• Rows with duplicate (From, To, Product, Mode) combinations will be rejected.
• Flow must be a non-negative number; negative values are not allowed.
• Open facilities are taken from the Opened Facilities sheet, not inferred from the Flows sheet.
• Any facility with non-zero flow must be listed in Opened Facilities. Facilities marked Include in the registered master data are always treated as open.
• The backend also checks flow conservation, supplier capacity limits, and other constraint consistency.

Differences from Standard Import

	Standard Import	ASIS Import
Purpose	Register network topology, costs, and constraints	Register current flow actuals as results
Sheets	20+ sheets	2 sheets
Prerequisites	None	Standard import must be completed first
Result handling	Results generated after running optimization	Results registered directly at import time

Inventory Optimization ASIS Import

Upload the safety stock you hold today so that it shows up as an inventory optimization result and can be compared against an optimized one.

Prerequisites

The target inventory optimization scenario must already have its data imported, the same way the network optimization ASIS import requires it.

Sample file	Purpose
example-import-inventory-optimization.xlsx	Standard import sample — use this first
example-asis-import-inventory-optimization.xlsx	ASIS import sample — use this after the standard import is done

Import Steps

1. Open the Inventory Optimization → Data tab and select the scenario.
2. Click Upload ASIS data in the left-hand menu.
3. Choose the Excel file and click Import.

The import runs as a job, the same as an optimization run. Once it completes, the imported result appears on the Results, Analysis, and Comparison tabs like any other result.

Excel File Format

One sheet named Safety Stocks. Row 1 is the header; data starts on row 2.

Column	Type	Required	Description
Location	String	Yes	Location name (must match a registered Locations.name)
Product	String	Yes	Product name (must match a registered Products.name)
Safety Stock	Float	Yes	Safety stock held today, in the product's quantity unit (0 or more)

Input Constraints

• Location and Product must match master data already registered in the target scenario.
• Duplicate (Location, Product) rows are an error.
• Safety Stock must be 0 or more.
• Nodes you leave out are treated as holding no safety stock, so list only your stocking points.
• Rows whose location and product are not part of the optimized network are ignored and listed on the Errors grid, so you can tell they were dropped.

What Gets Derived

Only the safety stock quantity comes from your file. Cost weighting, propagated demand, service level, cycle stock, and in-transit inventory are derived from the scenario's own input data through the same network the optimizer builds. That is what makes the total safety stock cost on the Comparison tab an apples-to-apples comparison.

Guaranteed service times are outputs of the optimization and cannot be inferred from a held quantity, so an ASIS result reports 0 for the guaranteed service time and leaves the inbound guaranteed lead time and net replenishment time empty. The lead time chart on the Analysis tab is therefore empty for ASIS results.