Overview of Input and Output Parameters in Excel |
PREVIOUS NEXT |
The input data to be executed by a scenario's ruleset and the resulting output data can be defined in, and reported, to an Excel workbook. Excel's tabular structure can be harnessed to define multiple input datasets in a single workbook. You can also define whether the data is to be used in a BOM or a XOM ruleset execution.
The structure of an input/output data workbook consists of multiple spreadsheets that declare the datasets and all data objects, and a configuration sheet that provides necessary parameters to process the data.
An input/output data workbook always includes the following two sheets:
Additional sheets are necessary when further objects are declared in the dataset:
Note that classical JDK classes (for example, Date, GregorianCalendar, and StringBuffer) are processed in-line and do not need to be declared in a separate sheet. The class type is declared in the second row of each class sheet, under the class name. It should not normally be changed, but if it is, a corresponding change is necessary in the rsm_config sheet.
| Note |
The colors used in the workbook can be configured in the rsmEmptyGridTemplate.xls template, found in the samples directory.
|
Defining parameters with Excel is subject to the following rules:
Avoid using data object labels that can match character strings in the parameters. For example, if you have defined a Customer object with an attribute "name" of type "java.lang.String" having the value "John", you must not use the label "John" to name this object. Use "John0", for example.
Rule Scenario Manager can reinstantiate classes that do not have a default constructor during an execution which uses the RSMXML (classical RSM serialization). However, if you use a different JVM like JRockit or an old JDK like 1.3, or if you have restrictions because of a Security Manager, a default constructor is required.
This limitation also occurs for an execution that uses the BOMXML serialization. To avoid having a default constructor in the BOMXML serialization, you can define the use of another constructor as described in the BOM serialization documentation.
| Note |
The Rule Scenario Manager Console does not work with jrockit81sp5_142_08. Use jrockit81sp6_142_10 instead.
|
| Copyright © 1987-2008 ILOG S.A. All rights reserved. Legal terms. Documentation homepage. | PREVIOUS NEXT |