Output Tables 

GENERAL TABLES INCLUDE

NODAL TABLES INCLUDE

"_Input_" Tables

"_Query_" Tables

AMStudyLog Output

Ancillary Output

Change Set Differences Output

CompositeReservoirDetail

Constraint_Summary

CustomDecisionVariables

EnergyConversion Output

EnergyConverter Output

FreqDurationStat Output

Fuel Output

FuelbyZone Output

Hub Output

Link Output

LTAvgPrice Output

LTBuildReport Output

LTCapacityLog Output

LTConstraintReport Output

LTMargResLog Output

LTResValue Output

LTScreeningCurve Output

LTStudyLog Output

LTVariableReport Output

MultiLink Output

ORDC Output

Pool Output

Portfolio Output

PortfolioContracts

PortfolioResourceEmissions

PortfolioResources

PortfolioSummary

PortfolioSummaryEmissions

PortOp_AnnualReport

PortOp_EfficientFrontier

PortOp_IterativeReport

PortOp_MarketOperation

PortOp_ResourceAcquisition

PortOp_ResourceOperation

PortOp_ResourceValidation

Resource Output

ResourceEmissions Output

ResourceGroup Output

ResourceGroupEmissions Output

ResourceStack Output

Risk Output

StudyLog Output

Uplift Output

Zone Output

ZoneEmissions Output

ZoneNativePrices Output

NodalArea

NodalBranch

NodalBus

NodalContingencyIslands

NodalCorridor

NodalDiagContingencyFlow

NodalDiagLoadSource

NodalDiagLODF

NodalDiagShiftFactor

NodalFTR

NodalGen

NodalHub

NodalInconsistent Gen

NodalIslandedSystems

NodalLMPContributions

NodalStudyLog

NodalTieFlow

NodalUnmapped AURORARes

NodalUnmapped LFGen

Change Database

This button is used to change the output database selection.  Select Change Database, navigate to and select desired database file, then select Open.  This also automatically changes the database selected in the Reporting folder under Simulation Options.

Restore Backup

This button is used to restore backup databases and recover the original data after a run has been started.  Backup database are only created when the Auto-backup output database option is selected on the File Menu > Options form.  When a run is launched that will write over an existing database the model will first copy the database as a backup before creating the new database.  The backup database is appended with "_bk" and stored in the same location as the original file.

 NOTE: Backup database are not available for MySQL type databases.  Furthermore, they are not automatically backed-up for SQL Server type databases until the user turns on the option in the user preference General Options.  Use care in selecting this switch, as backups for SQL Server type databases can take some time.

Hide Unused Tables

This button adjusts the grid view of output tables to limit the view to just those that have records or to show all possible tables regardless of whether they are populated.  The button will change from blue (as shown when active) to gray depending on the current setting.

Write Input to  Output

This button is used to add input data tables to the output database, which offers the ability to do Output Queries joining information between input and output tables.  This button functions much like the Write Selected Input to Output option (in the Reporting form of Simulation Options), in that it will write any input table that has the Report checkbox selected in the Input Tables Window.  The resulting tables will be listed with the "_Input_" prefix in the output database.

Delete Tables

This feature can delete multiple tables from the output database; it is useful in reducing file size or getting rid of unnecessary tables.

NOTE: Energy Exemplar strongly recommends making a copy of your database before using this feature.  Deleting tables is permanent and there is no undo action.

Step-by-step instructions to delete tablesStep-by-step instructions to delete tables

Read Dataset

This button reads the dataset from the current output database file.

Write Dataset

This button forces a write of the current data in memory.  If a run is stopped by the user, and output is desired, use this button to write the data currently in memory to the output database.

Clear Dataset

This button clears the output dataset.  To view a cleared dataset, select Read Dataset or use Change Database to re-select the output database.

New Query

This button is used to create queries, including joining tables to create a query using multiple output tables.  See Output Queries for more information.