Abstract: The compensation calculation system provides in one embodiment a promotion based system. A series of user interfaces allow a user to define an incentive program, such as a promotion program, for customers of an entity. In one embodiment, the definition of an incentive program includes the customers who will participate in the program, the products that are the subject of the program, various levels of attainments that must be met to obtain compensation, and the payout generation details. In one embodiment, attainments and payouts are determined using an efficient linear model of the form mA+b, where m is a multiplier, A is an accumulation value, and b is a static condition. The system efficiently determines accumulations relevant to the attainments and payouts using a combination snowflake data schema and nested set model to facilitate high performance determination of accumulation values.

Abstract: The compensation calculation system provides in one embodiment a promotion based system. A series of user interfaces allow a user to define an incentive program, such as a promotion program, for customers of an entity. In one embodiment, the definition of an incentive program includes the customers who will participate in the program, the products that are the subject of the program, various levels of attainments that must be met to obtain compensation, and the payout generation details. The system efficiently determines accumulations relevant to the attainments and payouts using a combination snowflake data schema and nested set model to facilitate high performance determination of accumulation values. “What-if” analyses can be undertaken in a reasonable amount of time to, for example, determine and/or compare different compensation payouts based on changing variables that affect compensation.

Abstract: The compensation calculation system provides in one embodiment a promotion based system. A series of user interfaces allow a user to define an incentive program, such as a promotion program, for customers of an entity. In one embodiment, the definition of an incentive program includes the customers who will participate in the program, the products that are the subject of the program, various levels of attainments that must be met to obtain compensation, and the payout generation details. The system efficiently determines accumulations relevant to the attainments and payouts using a combination snowflake data schema and nested set model to facilitate high performance determination of accumulation values. “What-if” analyses can be undertaken in a reasonable amount of time to, for example, determine and/or compare different compensation payouts based on changing variables that affect compensation.