1. A transaction filtering system for allocating credit for transactions among a plurality of business objects, the system comprising: a processor for executing instructions; storage configured to store commission allocation rules and to store transaction data associated with a plurality of transactions, each commission allocation rule being associated with at least one of a plurality of business objects and being generated using relationships between members of the plurality of business objects; and a query engine including processor-executable instructions for placing the generated commission allocation rules in a structured query language (SQL) query and generating a set of query results based on the SQL query.