Adding Variable Definition

The Add Variable Definition page enables you to add a variable by filtering through the required parameters. The options available to filter the data vary depending on the variable type selected.

To add variable definition, follow these steps:

1. Select the Add icon from the Variable Management toolbar.
   The Add button is disabled if you have selected any checkbox in the grid. The Variable Definition Add window is displayed.

   Figure 10-3 Variable Definition window

   
   

   

   
   
2. Enter the Variable details as described in the following table:

   Table 10-1 Variable Definition - Field Descriptions

   Field	Description
   Folder	Select the folder in which you want to create the variable.
   Variable Name	Enter a name for the variable. Ensure that there are no special characters like `, {,},", ', ~, <,>, /, \, and multiple spaces.
   Variable Description	Enter the required description for the variable.
   Variable Type	Select the variable type from the drop down list. The available options are: Commodity Variable Correlation Variable Currency Variable Equity Variable General Macroeconomic Indicator Variable Idiosyncratic Variable Interest Rate Variable You can add a custom variable type by clicking the Add icon and entering a Variable Type name in the Variable Type window.
   Variable Structure	Select the Variable Structure as either Single Value or Term Structure from the drop down list. The Term Structure option is available only if the Variable Type is selected as Commodity Variable or Interest Rate Variable. Click the Edit icon from the Term Structure toolbar. Select the required variables from the Variable Browser window.
   Single Maturity	This field is displayed only if Variable Type is selected as Commodity Variable or Interest Rate Variable: Select the Maturity Unit as Days, Months, Quarters, or Years from the drop-down list. Select the Maturity Type as either Value or Node.
   Maturity Value	This field is displayed only if Commodity Variable or Interest Rate Variable is selected as Variable Type and Maturity Type is selected as Value. Specify a numeric value between 1 to 1000.
   Node Selection	This field is displayed only if Commodity Variable or Interest Rate Variable is selected as Variable Type and Maturity Type is selected as Node. Click and select the required hierarchy from the Hierarchy browser window. Click and select the required node of the selected hierarchy from the Hierarchy browser window.
   Based On	Select any of the following options from the drop-down list, based on which the variable definitions are created. Hierarchy Measure Business Processor Entity
   Variable Classification	Select the required variable classification from the drop-down list. The options are Numeric Variable, Nominal Variable, and Ordinal Variable. The Nominal Variable and Ordinal Variable options are available only if you select Variable Type as General Macroeconomic Indicator or Idiosyncratic Variable and Based on as Hierarchy.
   Variable Transformation	This feature is available for variables based on Measures, Business Processor, and Entity. Click Transformation to define a transformation for the Variable. The Technique Browser for Transformation window is displayed. Select the transformation you want to apply to the variable and click the Forward Arrow icon. The options are Arithmetic, Exponential, Logarithm, Power, and Trigonometric. Click the Upward Arrow icon or Downward Arrow icon to change the order in which the transformation has to be applied. Click OK. If Arithmetic is selected, select the Operator (Addition, Subtraction, Multiplication, and Division) from the drop-down list and enter the Operator Value. If Logarithm is selected, select the Base from the drop-down list. The options are 10, 2, and e. If Power is selected, enter the value of Power. If Trigonometric is selected, select the Function from the drop-down list. The options are Sine, Cosine, and Tangent. If Exponential is selected, the exponential value of the variable will be considered for the transformation of the variable.

3. If the variable is based on Hierarchy, follow these steps:
   • Select Variable Property as Direct or Dummy (variable in Binary form and used mainly in regression analysis). The Dummy option is available only if Variable Type is selected as General Macroeconomic Indicator or Idiosyncratic Variable.
   • Select the required Hierarchy from the Selected Hierarchy drop-down list.

     Note:

     Hierarchy-based variables cannot be created on multi-level Business Intelligence hierarchies.
4. If the variable is based on Measures, follow these steps:
   • Select Yes or No adjacent to Apply Filters.
   • If Yes is selected, perform the following steps:
     • Select the Dataset from the drop-down list. You can click to view the details of the selected dataset.
     • Select the Measure from the Selected Measures drop-down list. You can click the Add icon to add a new Business Measure.

       For more details on creating a Business Measure, see the Creating Business Measure section in the Oracle Financial Services Analytical Applications Infrastructure User Guide.

     • Click the Edit icon in the Filters grid to open the Hierarchy browser.
     • Select the hierarchy member(s) and click OK. The selected members are displayed in the Filters grid.
     • Click a hierarchy member to invoke a grid with the member name.
     • Click the Edit icon in the hierarchy member grid and the Hierarchy Browser window is displayed.
     • Select the node(s) and click OK. The selected nodes are displayed in the Hierarchy member grid under Nodes.
   • If No is selected, select the Measure from the Selected Measures drop-down list. You can click the Add icon to add a new Business Measure.

     For more details on creating a Business Measure, see the Creating Business Measure section in the Oracle Financial Services Analytical Applications Infrastructure User Guide.

5. If the variable is based on Business Processor, follow these steps:
   • Select the Business Processor from the Selected BP drop-down list.

     You can click the Add icon to add a new Business Processor.

     For more details on creating a Business Processor, see Adding a Business Processor section in theOracle Financial Services Analytical Applications Infrastructure User Guide.

6. If the variable is based on Entity, follow these steps:
   • Click Entity to open the Entity and Attribute window.

   The available tables are displayed under the Available Entities section.

   • Select the checkbox corresponding to the table you want to select.

     The available columns in the selected table are displayed under the Available Attributes section.

   • Select the Attribute for which you want to create the variables and click Save.

     The selected attributes are displayed in the Selected Attributes section.

7. Click Save to save the new Variable definition details. The Audit Trails grid at the bottom of the Variable Definition window displays metadata information about the Variable definition created.