Output tables

There are a number of features you can use with output tables:

• Searching output tables - You can search within the list of output table names using the output tables filter. tart typing in the output tables filter. Output table names that contain the characters are displayed.
• Filtering output data - Output tables offer the same filtering features as the input tables. See Filtering table data for detailed information.
• Sorting output data - Output tables offer the same sorting features as the input tables. See Sorting the table for detailed information.
• Freezing output table columns - Output tables offer the same column freezing features as the input tables. See Freezing columns for detailed information.
• Exporting output data - Output tables offer the same export features as the input tables. See Data table export for detailed information.

Data limits in output tables

Numeric data in output tables is typically stored in one of these SQL data types. Each data type has limits to the values that can be stored in them:

• Money - Used to store cost values. Values must be in the range -922,337,203,685,477.5808 to 922,337,203,685,477.5807.

• Float - Used to store non-cost numeric values that may contain a decimal component. Values must be in the range - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308

• Int - Used to store non-cost numeric values that do not contain a decimal component. Values must be in the range -2,147,483,648 to 2,147,483,647.

• Keep in mind that if values exceed the ranges identified, they cannot be read into the model output tables when running a scenario. If this occurs, the run log will include information similar to the following, noting an arithmetic overflow has occurred:

OperationStepBegin: Importing OptimizationOutputSiteSummary.txt into OptimizationOutputSiteSummary

Notification: Arithmetic Overflow.

OperationCompleted: Arithmetic Overflow.: Failed

If you are using large numeric values to force certain behaviors, you may encounter this issue. This is especially true when assigning large costs in input tables. When the costs are applied to large numbers of items, the result can exceed the limit on a Money column.