Patent Document ID: 9495691
Application ID: 10319053
Patent Flag: 1

Claim One:
1. A computer-implemented compensation calculation system to determine payouts to customers of an entity who participate in one or more promotion programs, the system comprising: a processor; a memory coupled to the one or more processors, wherein the memory includes stored data and the stored data includes an arrangement of tables in a multi-dimensional database having a central fact table with entries that point to multiple dimension tables that store data representing at least multiple customers, a hierarchy of customer groups represented in a first nested set model, multiple products, and a hierarchy of product groups represented in a second nested set model, the memory also includes stored data comprising multiple attainment details, multiple payout details, multiple transactions per customer associated with multiple products purchased per customer, and details for multiple promotion programs associated with the multiple transactions; wherein the memory also includes code stored in the memory and executable by the processor to configure a computer system into a compensation calculation system machine to: provide a user interface to allow (i) selection of a customer group within the hierarchy of customer groups to select customers within the selected customer group included in the database that are allowed to participate in a promotion program and (ii) selection of at least one of: (i) a product group within the hierarchy of product groups to select products with the selected product group for inclusion in each of the promotion programs and (ii) selection of one or more products for inclusion in each of the promotion programs; receive the selection of the customer group and selection of products; cause one or more user interfaces to be displayed to the selected customers of the entity, wherein each user interface includes one or more components of one of the promotion programs for the customer to whom the user interface is displayed, wherein the components include (i) at least one of the payout details in the stored data that includes specifying performance levels associated with different payouts and (ii) at least one of the attainment details in the stored data; generate a query against the database to identify all transactions for the purchase of one or more of the products by all selected customers in each accumulation of a promotion incentive program; store a result of the query in at least one accumulation value for each of the selected customers; access the attainment details and each accumulation value for each selected customer to determine whether the customer has achieved one or more attainment objectives; and determine a payout, in accordance with the payout details, to each selected customer and who has achieved the one or more attainment objectives.