Resource Governor > Working With Business Rules

Working With Business Rules

Topics:

The left pane of the main Resource Management screen contains the Business Rules folder, which allows you to access the wizard. The wizard is a tool that allows you to create BRL statements accurately and quickly, using a dialog box that will generate rule syntax for you. The Business Rules folder also contains a plain text editing facility, where you can customize the rules or create a new rule rather than using the wizard.

Creating Business Rules

How to:

When you right-click the Business Rules folder, a shortcut menu is available, as shown in the following image.

For additional information about building rules with BRL, see Business Rule Language (BRL).

Procedure: How to Create a New Business Rule Using the Wizard

  1. Launch the Web Console.
  2. Click the Resource Management option on the sidebar.
  3. From the navigation pane, right-click Business Rules, and click Add using Wizard.

    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:

    Super User

    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.

    Allow PRINT * or SELECT *

    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.

    Number of WHERE or IF tests

    This setting allows you to specify the number, and name, of a condition.

    • How many tests? Allows you to specify that a certain number of conditions or relational clauses are required on a data request. Values can be 0-256. The default value is 0.
    • With a field name? Allows you to require a specific field name.
    Limit joined data sources

    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.

    Cartesian product refinement

    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 those 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. If you do not already have a rule that requires all requests to have a WHERE or IF test, you can select Yes. If an existing rule that requires all requests to have a WHERE or IF test is active, select No.

    Disallow access to all data

    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.

    Disallow access to a data source

    Allows you to disable a data source name from reporting availability.

    Disallow Client type access

    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 ReportCaster can be limited to specific times of the day or to a specific service of the server.

  4. In this example:
    • From the Allow PRINT * or SELECT * drop-down menu, select No.
    • From the Limit joined data sources drop-down menu, Yes.

      When Limit joined data sources is set to Yes, an additional box opens. Enter 3 in the box provided.

  5. Click Next.

    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:

    Verify Rules button

    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.

    Save As button

    Saves the new rule.

    Select All

    Selects all of the syntax in the window.

  6. Click the Save As button.
  7. Enter a name for the new business rule, (for example, br1), and click Save As.

    Note: All business rule 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.

Procedure: How to Create a Business Rule Using the Editor

  1. Launch the Web Console.
  2. Click the Resource Management option on the sidebar.
  3. From the navigation pane, right-click Business Rules and click Add using Editor.

    The New Business Rules window opens.

  4. Enter the syntax for the new business rule and click the Verify Rules icon to check your code. Correct any errors and then click the Save As button.

    For more information on building rules with BRL, see Business Rule Language (BRL).

Procedure: How to Delete Rules Files

  1. Launch the Web Console.
  2. Click the Resource Management option on the sidebar.
  3. From the navigation pane, right-click Business Rules and click Delete Rules files.

    The Delete Business Rules files pane opens.

  4. Select the rule you want to delete and click Delete.

    The rule will be deleted from the Business Rules folder.

Editing Business Rules

How to:

When you right-click an existing rule, a shortcut menu is available, as shown in the following image.

Procedure: How to Edit Existing Business Rules

  1. Launch the Web Console.
  2. Click the Resource Management option on the sidebar.
  3. Expand the Business Rules folder, right-click the rule you want to edit, and click Edit.

    The Edit Business Rules pane opens, as shown in the following image.

  4. Make any necessary changes, verify the rule changes by clicking the Verify Rules button, and then click the Save button.
    Note:
    • A rules file that is being used in one or more Knowledge bases cannot be changed. Any changes have to be saved to a different name, or the Knowledge base files have to be deleted first.
    • If a rule file that is in use is edited, a warning window opens and the Save button is not available. Click OK to continue.
    • To save the rule under a different name, click the Save As button and enter a new name.
    • When a business rule is edited, it will always open in the Edit Business Rules window, regardless of how it was originally created.

Procedure: How to Delete an Existing Rule

  1. Launch the Web Console.
  2. Click the Resource Management option on the sidebar.
  3. Expand the Business Rules folder, right-click the rule you want to delete, and click Delete.

    A confirmation window opens.

  4. Click OK.

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

Feedback