Parameters tab of the Model Modification screen consists of the following components: 

Data Model Input Field 

In the Data Model input field you need to enter the name of the Model you intend to modify. 

 button opens the lookup listing available mode, ls. 

button opens Data Model Editor where you can modify the selected Data Model setup. 

Hierarchy Pane
In the Hierarchy panel, the structure of the selected Data Model is displayed. Here you can build additional hierarchies to the existing setup. This is done by adding nodes to the existing structure of the selected Data Model and setting up their parameters. 

Added nodes need to be renamed according to their purpose. The names of the node should correspond to the names of the sources assigned to them. These names will serve as aliases for these sources in subsequent mappings and other data base operations. 

button adds a child to a selected node; 

button removes selected child nodes; you are not allowed to remove the root node. 

buttons move a selected node up and down within its hierarchy level. 

Properties Pane
On the right hand side of the Parameters tab, the Properties pane is located. It changes dynamically depending on what node is selected in the Hierarchy Pane and provides input areas to set up parameters that are necessary for the new model to function. 

Basic Model Modification sequence may include: 

1. Altering properties of the existing nodes: 

a. Editing/adding Optional Constraint b. Editing/adding Additional joint Expression
c. Editing/adding Join Fields 

2. Adding sources to the selected nodes
3. Adding sources to the additional nodes 

Note: The system will not allow you to delete sources from the existing structure. 

If the Root node is selected, the Properties panel displays a set of parameters relevant to the Main Source of the selected Data Model (Fig. ). 

If one of the hierarchy nodes is selected, the Properties panel displays a set of parameters relevant to the source assigned to this node (Fig.). 

Modify Node Switch
Modify Node switch at the top of the Properties pane (Fig.) appears when one of the existing nodes is selected. By default, it is set on No. 

Modifying Existing Nodes
Initially, all parameters are dimmed with the exception of: 

1. Edit Source button which provides access to the Source Editor where you can modify the selected source. Exercise caution when doing this.
 
2. Join Fields pane (for the hierarchy nodes) allowing you to modify the Join setup. 

Changing the Modify Node switch from ‘No’ to ‘Yes’ activates the following parameters making them available for modification: 

1. For the Root node: Optional Constraint
2. For any of the existing Hierarchy nodes: Optional Constraint, Additional join expression. 

You can change the above parameters as you see fit. 

Optional Constraint
In this field, you enter a statement for data selection (i.e. $currency=’USD’) and this condition will be applied every time this data model is used. 

Use the  button to open the lookup listing column names to be used in the expression. 

Additional Joint Expression
Into this input field, you can enter an SQL expression to stipulate additional joint requirements. 

Use the  button to open the lookup listing column names to be used in the expression. 

Note: Contact AxiomSL support if you are not clear on all this. 

Building Modification Hierarchy Nodes can be added to any existing source in the selected data model hierarchy. 

To add a node: 

1. Select an existing node in the selected Data Model hierarchy
2. Use the button to insert a node
3. Rename the inserted node. 

Repeat steps 1 and two until all required nodes are in place 

Note: New nodes can be added to the existing and to the newly added nodes. 

Source Selection
When a node is added the Properties pane will display provisions for a new source selection as well as for setting up the parameters for its incorporation into the model (Fig.). 

Note: The names you give to the inserted nodes with which the selected sources are associated, will serve as the sources’ aliases. 

The following mandatory and optional parameters need to be set up in order for the new source to be added successfully to the Data Model. 

Data Source
Mandatory. Into this input field, you can enter the actual name of the Data Source you an adding to the Data model. 

Use the  button to open the lookup listing available sources. 

Relationship to Parent
Mandatory. Input here indicates how many records in the source correspond to a single record in its parent and vice versa. The menu (Fig. ) provides the following selections. 

Mandatory in Join Switch
Optional. Determines whether the data in this source will be available for viewing on the Filter screen. 

Optional Constraint
Optional. In this field, you enter a statement for data selection (i.e. $currency=’USD’) and this condition will be applied every time this data model is used. 

Use the  button to open the lookup listing column names to be used in the expression. 

Additional Joint Expression
Optional. Into this input field, you can enter an SQL expression to stipulate additional joint requirements. 

Use the  button to open the lookup listing column names to be used in the expression. 

Mandatory in Join switch
Optional. This Yes/No switch determines whether the data in the selected source will be available for viewing on the Filter screen. 

Instance Date Selection Rule Mandatory. This parameter indicates to the system what method of data selection should be used when creating a Model Instance. 

1. EQUAL (default) – The system will search for data for the same date as the Model Instance’s that is being created.
2. LATEST – The system will pick the data for the latest date prior to the Model Instance date.
3. Formula – Allows you to further refine Instance Data Selection by entering an expression. 

Join Fields Pane
Mandatory. On the Join Fields pane (Fig.) key fields that link the selected source with its parent are mapped. The pane’s grid has two columns – Source Field and Parent Field. 

Source Field refers to the name of the column in the current source. 

Parent Field is the name of the corresponding column in the Parent source. 

Join Column selection input fields in the pane’s Grid are used to select key columns in the current (left) and the parent (right) sources. 

Lookup  buttons open menus listing all columns available in their respective sources.