Update Structures Analysis Column

Before performing any analysis using the system, it is important to define the usage of each variable used in the system, particularly those used in the Network Master table. For instance, the system needs to be configured so that it can treat a variable as performance index, so the system will apply a corresponding performance model to this variable when it is being analyzed. In Structures Analyst, this configuration also determines which variables will show up in a particular window. So when you want to select a performance index, you select from a list of index options instead of all the variables in the system.

In Structure Analyst, this is configuration is done in the Analysis Column window which can be navigated to by following the steps below:

1. Select the Structures Analyst module
2. Click Setup in the top banner menu
   
3. Click Analysis Columns & Attributes in the drop-down menu

The system treats each column configured in this window as a variable and will apply the corresponding analysis routine to it.

Typically, columns in Network Master table will be configured here. Out of the box, the system is pre-configured for the existing Network Master columns.

Once a column (i.e., “variable”) is defined in the system, it can be added to this window and assigned with various functions by checking any of the corresponding fields (some of the field names may show up differently on different implementations). It is very common for a column to have multiple checked fields to serve multiple uses, for example, AADT can be a variable used in both decision tree and performance model structure. Each usage in the BMS Analysis Column window is explained as follows.

• Column ID: The Column ID of the attribute utilized during analysis
• Column Label: The Column Label for the attribute utilized in the analysis
• Decision Variable: Determines whether the selected column will be used in developing the treatment decision trees. If selected, the column will appear in the decision variable list shown in the dialog box displayed by selecting Edit Decision Var Limits command in the Edit/View tab of the Decision Tree window
• Performance Class Variable: Determines whether the selected column will be used in developing the performance model structure. If selected, the column will appear in the decision variable list shown in the dialog box displayed by selecting Edit Decision Var Limits command in the Default Model Structure window
• Deteriorates: Determines whether the system will treat the selected column as “performance index” (PI) and apply a performance model to it. If selected, the column will appear:
• In the Condition Attributes drop-down list in the Improvements pane of the Treatments window
• In the BMS Analysis Index drop-down list in the Network Analysis window
• As columns in the Road Sections pane of the Section Current Needs window
• As rows in the Attributes pane of the Performance Model window
• Upper Level Dec Tree Variable: Determines whether the select column is used in developing the upper-level treatment decision trees. If selected, the column will appear in the Upper Level pane in the Selection tab of the Decision Tree window
• Used in Expressions: Determines whether the selected column is used in calculated expressions. If selected, the column will appear in the right pane in the Calculated Expressions window and so can be used in calculated expressions
• Analysis Scope Variable: Determines whether the selected column will be used in defining the scope of the network optimization analysis. If selected, the column will appear in the Edit Scope dialog box that is displayed by selecting the Edit Scope command in the Network Analysis window
• Default in Analysis: Contains a value supplied for the column when it has no value in either the Network Master
• Allow Change After Treatment: Determines whether the selected column's values will change after a treatment - where the values are not based on a performance model (i.e., a non-PI-based attribute, for example, Structure Type change after a specific type of treatment). If selected, the column will appear in the drop-down list in the Changing Attributes column of the Other Improvements pane in the Treatments window
• Change with Year SQL: Contains the SQL that determines how the value of the non-PI-based attribute changes annually in the future for scenario analyses, using the value from previous year as input, for example, AADT (to represent an annual growth) and Structure Age (to calculate the next year from last year)
• Update Order: For non-PI-based attributes, this field contains a number that indicates the order in which the attributes will be updated when multiple attributes either have "Change with Year SQL" in this window or are shown in the Other Improvements pane in the Treatments window
• Is Constraint Column: Determines whether that the selected column may be used as a constraint in the network optimization analysis. If selected, the column will appear in the drop-down list of the Constraints pane of the optimization analysis window
• Is Add Constraint Column: Determines whether that the selected column may be used to set up the sub-division constraint in the network optimization analysis. If selected, the column will appear in Setup Constraint Subdivision window
• Change with Time Groovy Script: Equivalent to the Change with Year SQL field except that Groovy scripts are utilized rather than SQL
• Groovy Script for Calculated Columns: Shows the Groovy script that calculates the value of the column. It is used in analysis in all future years

Once the usage of each column from Network Master has determined, you can go into the relevant functional area and configure them separately.