IBM Decision Optimization Center Solutions Accelerator

IBM Decision Optimization Center Solutions Accelerator provides components enabling the execution and customization of optimization solutions developed with IBM Decision Optimization Center.

Solutions Accelerator consists of two editions: the "Client Edition" and the "Server Edition".

The documentation set is installed locally at  Solutions Accelerator Documentation.


IBM Decision Optimization Center Solutions Accelerator Client Edition

The client edition consists of the following components:

  1. Smarter Planning and Scheduling for Manufacturing (SPSM)

    This component provides the capability to manage configurable solutions for Decision Optimization in the area of planning and scheduling in the manufacturing industries. It supports configurable solutions in the following areas:

    The Solution Workbench, available through an IBM website, is used to configure SPSM solutions. The workbench enables the creation of domain models and technical components that can be configured and assembled into solutions usable with Decision Optimization Center. Solutions can be customized and extended using the APIs from Solutions Accelerator.

  2. Advanced Interactive Gantt

    This visualization component provides an abstract Decision Optimization Center custom Gantt view that greatly reduces the effort required to build interactive scheduling applications. This component extends the Gantt component provided by Decision Optimization Center to add some features not found in the base Gantt component. This component is built using IBM ILOG JViews Gantt (delivered with Decision Optimization Center) and can be extended using the APIs from Solutions Accelerator and JViews.

  3. Decision Optimization Center View Utilities

    This component provides a set of utilities to support the execution of custom views provided in the IBM Industry Optimization Solutions, particularly filtered aggregated Chart Views.

  4. Data Exchange

    This component provides the capability to define and orchestrate advanced data import and export jobs between Decision Optimization Center and external components. It requires IBM DB2 V9 or V10 (including IBM DB2 Express-C V9 or V10).

  5. SPSS Modeler Connector

    This component provides the capability to execute Decision Optimization Center custom tasks based on SPSS Modeler Streams. This component requires IBM SPSS Modeler Client 14.2 or IBM SPSS Modeler Server 14.2, and IBM SPSS Modeler Batch 14.2, or later versions.

  6. Support for Microsoft Excel Scenario Source

    This component provides the capability to load Microsoft Excel spreadsheets into a Decision Optimization Center Scenario, or to export Decision Optimization Center Scenario tables to Microsoft Excel. The component uses a structural pattern based on the Decision Optimization Center Data Table Schema to load or export the Excel data.

    This component requires Apache POI version 3.9, which can be downloaded here: http://poi.apache.org/download.html

    The following POI libraries need to be copied to the lib/external folder of the Solutions Accelerator Client Edition installation directory:

  7. Decision Optimization Center Customization Utilities

    This component provides a set of utility classes that help with the customization of a Decision Optimization Center application.

The libraries for the Client Edition can be found at  <install_dir>/SolutionClient/lib

Also see the  Client Edition Java Reference Manual.


Getting Started

Using the Gantt Component

The Gantt component is an abstract base class that implements a custom view for a Decision Optimization Center application. It makes it possible to display resources and activities in a Gantt custom view and provides application-specific actions, styles, and interactions in the Gantt component.

  1. Deriving the Gantt view.

    Each Gantt custom view must derive the class GanttView.

    The Gantt view must be declared in the views.odmvw file. An example is shown below (note that the "id" and the "prefix" must be identical):

       <view display="Gantt View" icon="ganttview.png" id="schedule">
        <customView implementationClassName="psched.views.ScheduledActivitiesGantt">
          <arguments>
            <arg name="prefix" value="schedule"/>
            <arg name="customProperties" value="/custom.properties"/>
          </arguments>
          <dependencies/>
        </customView>
      </view>
      
  2. Configuring the Gantt view.

    Some basic configuration of the Gantt view is possible using the custom.properties application file. An example properties file can be found here.

Executing SPSS Modeler tasks

SPSS Modeler connector is provided with Solutions Accelerator Client Edition. With the client edition, you can execute custom tasks with IBM SPSS Modeler running locally using Decision Optimization Center Planner, or "partially remotely" using IBM SPSS Modeler server. You can execute tasks fully remotely using Decision Optimization Center Optimization Server (available in the Solutions Accelerator Server Edition). SPSS Modeler tasks are configured the same way whether they are run locally, partially remotely, or fully remotely.

An SPSS Modeler task covers these typical activities:

The SPSS Modeler connector uses the SPSS Modeler Batch executable (clemb.exe) to execute the SPSS Modeler tasks. This executable is provided in SPSS Modeler Client, and as a separate module SPSS Modeler Batch of SPSS Modeler Server.

For documentation on SPSS Modeler task configuration and execution, see the package datax.spss.

For documentation on Decision Optimization Center to SPSS Modeler stream mapping, see the package datax.config.

Using Microsoft Excel Scenario Source

A custom Excel data source is provided to import data in a Decision Optimization Center Scenario, using a structural pattern that is based on the Decision Optimization Center Data Table Schema.

The custom data source must be defined in the .odmds configuration file as shown below:

    <scenarioSource id="Excel Data Source" inAdd="true" inReplace="true">
      <template>
        <message>Load data from Excel template file {0}</message>
        <args>
           <arg type="string" id="filename" defaultValue="ECRData_1.0.xls"/>
        </args>
      </template>
      <customSource javaClass="com.ibm.optx.shared.utils.xls.ExcelTemplateScenarioUpdater">
        <initargs>
          <arg name="executedTask" value="optimizeOverallRepositioning"/>
        </initargs>
      </customSource>
    </scenarioSource>
  

The initargs section of the customSource is used to configure values in the Parameters table of the scenario.