-
From the Home page, select Administration > Global Setup > Parameters.
-
Click Add Row in the Parameters section.
-
Type a parameter name in the Parameter cell.
-
Type the descriptions in the Short Description and the Description cells.
-
Select Yes in the Standard list if the parameter is a standard parameter
Standard parameters are parameters that are delivered with the software and are not editable.
-
Select Yes in the Mandatory list to indicate that the parameter is mandatory.
-
Select an option from the Lexical list:
-
Lexical Where-Clause - to assign a variable SQL where condition to the parameter.
-
Lexical Order-By-Clause - to assign a variable SQL Order statement to the parameter.
-
No lexical parameter - to assign discrete values to the parameter in the Parameter Values block.
-
-
Select Yes in the Modifiable list to modify the standard parameter values.
Standard parameters are not editable. You can edit/modify the standard parameter values by setting Modifiable to Yes.
-
Select a parameter from the Parameter Type list:
-
Module specific - specifies that the parameter applies only to a specific Smart Materials module
-
Product wide valid - applies to all the modules of Smart Materials
-
System (Oracle Reports) - applies to, for example, report parameters
-
Administration - applies to, for example, project defaults
-
-
Select a data type from the Data Type list.
-
Select a query type from the Query Type list:
-
Query - specifies that the list of values should be based on a query set.
-
Static - specifies that the list of values should be based on static values. Type the list of values in the Parameter Values section.
-
-
Based on the query type selected in Step 11, do the following:
-
For Query type, enter the select statement in the Command cell.
-
The select statement must return two values.
-
The title of the list of values must be defined at the end of the select statement and must be enclosed in /* */. For example, the LOV of parameter ZB_LST_ID is defined as:
select LST_ID, LST_CODE from m_list_status /* B.10.02 List Status */
-
-
For Static type, enter the list of values in the Parameter Values section.
-
-
Type a table column.
-
Type an alternative command in the BIR Command cell if the parameter is a report parameter.
For more information on BIR, see Smart Materials Business Intelligence Reporting User’s Guide.
-
To check the conditions of the parameters, select a parameter and click Check Conditions.
-
You can add multiple check conditions and all the check conditions must start with Select count(*).
-
You can validate the check condition that are either equal to zero or greater than zero.
-
For checking the conditions of a parameter, the selected parameter must not have parameter values defined.
-
Define parameter values
-
In the Parameter Values section, click Add Row.
-
Type a Parameter Value.
-
Select Yes from the Default list to make the parameter value as the default value.
-
Type a comment and then click Save.
-
To set the conditions that must be fulfilled for a parameter value, select a parameter value and click Check Conditions.
For checking the conditions of a parameter, the selected parameter must not have parameter values defined.
-
In the Parameter Check Conditions pop-up, click Add Row.
-
Type the Check Statement.
-
You can add multiple check conditions and all the check conditions must start with Select count(*).
-
You can validate the check condition that are either equal to zero or greater than zero.
-
-
Select a condition from the Condition list.
-
Type a comment and then click Save.