In this section: |
The left pane of the main Resource Management screen contains the Business Rules Folder, a tool that allows you to create BRL statements accurately and quickly, using a dialog box that will generate rule syntax for you. It also contains a plain text editing facility, where you can customize the rules or create a new rule rather than using the wizard.
|
|
How to: |
When you right-click the Business Rules folder, a context menu is available, as shown in the following image.
For additional information about building rules with BRL, see Business Rule Language (BRL).
|
|
The Resource Governor New Business Rule pane opens, as shown in the following image.
The Resource Governor New Business Rule pane has the following options:
A user ID that is entered into the rules that will be allowed to execute any request that may be canceled by the governor under normal operating. A user ID may be up to 48 characters in length. Selecting Yes from the drop-down menu will open a text field for the user ID input.
This setting allows the user to set whether or not a rule will be written. If Yes is selected, a rule will not be created and a SELECT or PRINT * may be used at any time in a data request. If No is selected, a rule will be written disallowing the condition regardless of any other rules in the source. The default value is Yes.
This setting allows you to specify the number, and name, of a condition.
The number of data sources used in the request. The limit is 16 and the default value is 0, or No. Selecting Yes will open a text field for input.
A Cartesian product occurs when two or more data sources are joined without any selection criteria. This produces an uncontrolled display of all possible connections between that tables. Requiring a WHERE or IF refinement prevents a Cartesian product from being issued. If Yes is selected then one or more WHERE or IF clauses must be used to limit the data returned by the request that uses more than 1 data source. If No is selected then all data for the request columns in the joined data sources will be returned. You do not have a rule that requires all requests to have a WHERE or IF test to use this rule, but if the rule that requires all requests to have a WHERE or IF test is active then this rule is not required.
Allows you to specify a time of day when data reporting is not allowed. The times are based on a 24 hour clock. The values allowed are 0000-2359.
Allows you to disable a data source name from reporting availability.
The type of Client being used to submit a request can be tested for and if necessary the request can be canceled. For example any request that is submitted from Report Caster can be limited to specific times of the day or to a specific service of the server.
The New Business Rules window opens showing the generated code, as shown in the following image.
The New Business Rules window has the following buttons:
Allows you to verify BRL syntax at any point while building rules. If there are no syntax errors, control is returned to the editor window with the rule text. If there are errors, a dialog displays error messages.
Note: The errors need to be corrected before you can continue.
Saves the new rule.
Note: All business rules names in Resource Governor must be eight characters or less.
The new business rule is now listed in the expanded Business Rules folder in the navigation pane.
|
|
The New Business Rules window opens.
For more information on building rules with BRL, see Business Rule Language (BRL).
|
|
A confirmation dialog box opens.
|
|
How to: |
When you right-click an existing rule, a context menu is available, as shown in the following image.
|
|
The Edit Business Rules window opens, as shown in the following image.
|
|
A confirmation window opens.
The rule will be deleted from Resource Management.
Note: A rules file that is being used in one or more Knowledge bases cannot be deleted. The Knowledge base files have to be deleted first.
|
WebFOCUS |