Group your business rules with a frequently used input field to reduce the number of
rows to process. Grouping splits your business rules into multiple groups and evaluates only the
required group.
Required Editions
Available in: Lightning Experience
Available in: Enterprise, Performance, and Unlimited Editions with Loyalty Management
or Rebate Management
Note Decision tables are also available as part of Business Rules
Engine. If your org has Business Rules Engine enabled, see Decision Tables for Business Rules Engine.
Group business rules to invoke a decision table that evaluates fewer than 10,000 rules up to
1.5 million times per hour. And a decision table that evaluates more than 10,000 rules up to
150,000 times per hour. We recommend that the input field that’s used to group business rules
divides the data with fewer than 1,000 records in a single group.
Example A shoe company that has 30,000 business rules determines the discount percentage by shoe
type and by the quantity purchased. The company specifies Maximum Quantity, Minimum Quantity, and
Shoe Type as inputs and Discount as the output. The input field condition is All conditions are
met (AND) and Shoe Type is the input field that groups the business rules. By grouping the
business rules for discounts by shoe type, the company brings down the number of rules to query
to 900.
Example An airline company data contains 30,000 business rules with input fields such as Source,
Destination, Miles, and Class. Group the business rules with the Source field to limit records in
each group to below 1,000. The decision table can now be invoked up to 150,000 times per hour.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
