A LITIC App from Start to Finish

(with only drag & drop operations throughout)

A Typical Problem

Your client is a beer distributor who wants to analyze a network of warehouses from which to supply his customer’s facilities.

His main planning objective for the upcoming year is to minimize the combined transportation and warehouse costs by selecting only some of the warehouses. Of course, he must consider both customer demand and warehouse capacity as binding constraints.

The following steps demonstrate how you could proceed to produce a first plan for your client using LITIC Software.

Step 1   External Data

First, select an external spreadsheet containing:
  • latitude and longitude data (shown below)
  • demand and supply data
  • transport and inventory cost data.
Next, specify the cube-and-dimension structure (also known as the measure-and-key structure) of the data inside the ETL facility.
Then, start looking for possible data errors.
The system will check for obvious errors:
  • cells with data type errors
  • duplicate cells with inconsistent data
  • missing dimension labels.
You can also specify your own error checks:
  • impose value type and value range checks
  • check for missing data
  • specify dimension consistency across sheets.
Next, check for errors in the data.
Finally, click on the ‘Load Data’ button to enter all dimension and cube declarations (including their properties).
    View Step 1: Import External Data

Step 2   Specify Your Application Logic

First, use drag & drop to build the assignment statements shown below.
Next, build and solve an optimization model (also using drag & drop)
    View Step 2: Specify Your Application Logic

Step 3   Visualize Your Data

First, show the solution in the geographic map (drag & drop the necessary cubes inside the edit dialog).
Next, show the solution inside charts.
    View Step 3: Visualize Your Data

Step 4   Build and Deploy a Two-Page App

The LITIC App design studio provides all necessary functionality to develop the interactive web app.
    View Step 4: Build and Deploy a Two-Page App