Creating rule logic by using tools in the Tabbed Palette

When you create rule definitions and data rules, you have the option to use the Tabbed Palette, in the right side of the data rule workspace, to assist you with defining your physical data sources.

When you build data rule definitions, you can either type in logical names for elements in your data rule definition or use the tabbed palette to select data descriptions for your data rule definition. If you select a column from the Implemented Data Resources, Physical Data Models, or Logical Data Models tab, you can create a rule variable with the same name as the column from the data source, and the column becomes the default binding (the design binding) for the variable. When you create a rule from this rule definition, the binding panel is automatically populated with the design binding. During the binding step you can reference the design binding to assist in the selection of the implemented binding that designates the data to be evaluated at execution time.

If you select a global variable from the Global Variable tab, you can create a rule variable by using the same name as the global variable, and this becomes a design binding for this variable. When a rule variable is bound to a global variable, the value of the global variable is used in place of the rule variable at execution time.

If you select a term from the Term tab, then you are simply referencing a standard business description as populated through IBM® InfoSphere® Business Glossary. This does not create an explicit link to the term, but does help you standardize the language of your rule definition. You can also select a function from the Function tab.

The bindings that you create between your data rule definition components and actual tables or functions by using the Tabbed Palette will be carried into your data rules.

When you create rule definitions and data rules, you can choose from the following options to define your data:

Global Logical Variables: A global logical variable is a representative value that you can set to represent a fact or a specific piece of data. You can create global variables to hold values or parameters which are valid system wide, such as currency exchange rates, a credit rate, or any other value used by a company. You can create a global logical variable for one rule definition, and then reuse it in all your rule definitions and data rules. Before a rule definition can be used, all global logical variables must be “bound” to a concrete concept, such as a physical source column, a defined constant, or other such physical representation, along with all of the other rule variables in the rule definition. When you specify a global logical variable when you are building your data rule definition, the global logical variable becomes a default binding when you generate a data rule.
Functions: Data rule functions can be used to perform specific operations when you build rule definitions and data rules. Functions are populated in the Source Data or Reference Data fields in the data rule logic builder. Select the functions that you want to use to perform a particular action on your data such as COUNT , SUM, or AVG(value). You can choose from the functions listed under the Functions tab.
Implemented Data Resources: Click the Implemented Data Resources tab in the Tabbed Palette to define a default binding to specific columns in the tables of data sources in your project when you build data rule logic. Defining data sources is useful when you have an idea of how you want your rule logic to work, and you have particular data in mind. By using the Implemented Data Resources tab, you are creating a shortcut to the data source by creating a rule variable with the same name that has a predefined default binding. After you create your rule definition and you generate a data rule out of the rule definition, you can either keep or change this binding. You can use the search box in the top part of the workspace to help you search for particular data sources.
Physical Data Models: Physical data models can be created in Publish Analysis Results pane. You generate a physical model by clicking Generate physical model and then specifying the required options. The generated physical model can be viewed in the list in the Physical Data Models tab.; Click the Physical Data Models tab in the palette to define a default binding to specific columns in the tables of physical data models when you build data rule logic.; The Usage tab of the data rule definition shows the combined hierarchy of Physical Data Model, Logical Data Model, and Implemented Data Resources variables which are involved in creation of the data rule definition.; You can add new table names in the Customization Name pane. Note that names must be unique. When a new table name is added, you can view the new table names by clicking the Preview button.
Logical Data Models: Click the Logical Data Models tab in the Tabbed Palette to define a default binding to specific columns in the tables of logical data models when you build data rule logic.
Terms: InfoSphere Business Glossary terms are business definitions that becomes a part of the IBM InfoSphere Business Glossary vocabulary and classification system. Use the Terms tab in the Tabbed Palette to define a default binding to specific InfoSphere Business Glossary term. Terms can only be viewed by users who have InfoSphere Business Glossary Author or User roles.