Reusable tool logic
Create reusable tools from existing tools. Define the data sources and configuration values for each tool and group them together to reuse them as needed.
Reusing existing logic helps to recreate similar pieces of logic to help you handle slight variations in your compensation plans. By using reusable logic, you can also use these assets across different pipe.
Add your reusable tools to the tool library. Give each tool a name and an optional description that describes your reusable logic.
When to use this logic
Use reusable logic when you want to reuse a specific configuration of tools.
For example, you have a set of tools that you require in more than one pipe. Before Reusable logic, you would have to recreate this logic in every pipe. With Reusable logic, you can create the logic once, save it to the Tools library, and use it as many times as required without having to manually create it over and over.
Naming conventions
When you name your tools, do so based on their function, not the object or data action. For example, if you use the Join tool with a Left join, you would name the new tool with Left Join in the title, such as Left Join for Adjustments.
Another example is Look up rate instead of Join to rate table.
Input
Group one or more tools together to create a new reusable part external to the calculation workbench.
Usage example
Let's say that you don't pay your payees in full immediately due to a traditional pattern of high returns. Instead, you pay your payees a set amount for each customer they sell to, but because the return rate is high, you want to hold the rest of the payment. There are two types of holds, one for 6 months and one for 12 months. Using reusable logic, you can have two independent calculations to handle similar logic.
Map all factors to define the component details, such as measurements, multipliers and rates. You want to use monthly for the 6-month and quarterly for the 12-month calculations. Because you have similar information, you use and split your attribute tables that have AttributeID columns to split and retrieve the different details on the compensation plan.