Create an output definition with a report class and database table to store the results of a simulation that you want to run. Output definitions determine how data instances (strategy results) map to data in a database table.
Click Designer Studio > Infrastructure > Simulation Settings > Output Definitions.
Click New.
Click Create.
In the Output Definition step, enter the name of the output definition, and select the strategy result class.
Click Next.
In the Database Configuration step, define the report class, the database, and the database table.
Class Name - The name of the data class that is created by the output definition. By default, the data class is configured based on the output definition name but you can change it if required.
Database - The name of the database table to which the results of the simulation are written. A new table is created in the process of running the simulation if the table does not already exist in the database. If the table already exists, it is dropped before the results of the simulation are written.
Create dedicated database table - If this option is enabled, the database table is created. If this option is disabled, the process of creating the database table is skipped, and the SQL script that allows for creating the expected database table is available in the Review step. Use this option if the database connection that is used for this output definition does not have the rights to create tables. In this case, it is assumed that the necessary steps to create the database table are in place before starting the simulation that uses this output definition.
Click Next.
Review the default properties and specify properties that you want to create. The first list of properties corresponds to properties in the strategy result class selected in the output definition step.
Optional: Select the Select additional properties from other classes check box if you need to add properties that are not in the strategy result class.
Optional: Click Add Item to define properties.
This step also displays the list of properties in the Data-Decision-StrategyExecution-ResultOutput class. These properties are inherited from the strategy's base class (Data-pxStrategyResult).
Click Next.
In the Review step, review the output definition, the database configuration, and the record that will be created.
If you disabled the Create dedicated database tableoption in the Database Configuration step, click Download SQL to obtain the SQL script with instructions for creating the table in the expected database.
Note: You must have the pySchemaBuilderAllAllowed privilege to download the SQL instructions.
Run the script before starting a simulation that uses this output definition.
Click Create.
On the Simulation Settings landing page, click Refresh.