Business Scenario: LP Workflow & Classic Setup

Business Scenario: LP Workflow & Classic Setup

This article is part of the Business Scenario series, split from the original Business Scenario article.

Business Scenario + LP Workflow

Section 1: Setup LP Model in Arkieva Classic

LP Model & Data Group Configuration

First, launch Arkieva Classic.
  1. Create a new Optimization Model in Classic
  2. Save
  3. Click on Settings, enter the SaaS tenant ID and check ‘Enabled in SaaS’
  4. Contact Arkieva Support to establish a connection between the LP Model and the SaaS tenant


  1. Open Data Versions screen and add ‘BusinessScenario’ to Data Group
  2. Select the Optimization Model under Supported Document





NOTE: We are working to automate this update to Data Version. In the meantime, please check and manually update if needed.

Setup LP Model Input Tables and Procedures

  1. Download the scripts with step-by-step instructions on how to set up the LP Model. 
  2. Contact Arkieva Support to get instructions and scripts.
The scripts will:
  1. Setup tables to receive and send data between SaaS and the LP in classic
  2. Create tables and views used to define the LP Scenario
  3. Create stored procedures to automate updates of these tables
Verify that the following stored procedures are present in the database:

Stored Procedure
Description
MaterialFlowGetLPScenarioID
Extracts the materialflow scenario ID and name.
PublishMaterialFlowInputPostProcess
Creates a new data version of BusinessScenario.
MaterialFlowPrepareLPData
Gets input data from optimization_materialflow tables. Calls two sub-procedures (see below).
  MaterialFlowUpdateOrbit2SP
Sub-procedure called by MaterialFlowPrepareLPData.
  Orbit2SP_PreProcessBigTables
Sub-procedure called by MaterialFlowPrepareLPData.
MaterialFlowPrepareResultTables
Populates the optimization_materialFlow.results tables after the LP solve.


In addition, get the latest versions of the standard “PostLP” procedures.  These are updated when you upgrade the Classic db.
  1. PostLPValidate
  2. PostLPResultsPublish

PostLPValidate
The latest version must include the following code in the Custom Validation section:




PostLPResultsPublish
Verify this procedure reflects the latest version from the reference database:




Create an LP Scenario

Open the Optimization Model and create a new LP Scenario with Type = ‘LPFromOrbit’. 
Mark this as the ‘Official’ scenario.


  1. Click on the Model tab to verify that the model was generated




Running LPs with Business Scenario

Run Logistics Engine Without Solve

  1. From the Material Flow tab, click on Settings and enter the SQL server and db name with the LP Model
  2. Make sure the RunTimeTool is installed and working




  1. From the Material Flow tab, create a new Business Scenario


  1. Create a new LP Scenario by copying the Official LP Scenario
  2. In the Scenario tab, scroll to DataGroups -> Business Scenario to select a business scenario for the LP scenario
  3. Run the LP Model
  4. Click on ‘Reports’ to review the results of the LP Model
  5. From the Scenario tab, click Publish to send the result back to Business Scenario
  6. The LP scenario will be listed in ‘Compare Scenario’ and ready to be applied to the Working Scenario

Publish Notification

  1. Run Publish
  2. Confirm you receive a ‘publish’ notification




Compare Scenario Results

  1. Navigate to Compare Scenario and compare the results




















Business Scenario series