A method of and system for defining a sales promotion including consolidating sales promotion data in a data warehouse are disclosed. The method includes receiving in a computerized system first and second sales promotion data corresponding to first and second sales promotions from the data warehouse, and grouping the first and second sales promotion data to define third promotion data corresponding to a third sales promotion. The system includes means for receiving first and second sales promotion data corresponding to first and second sales promotions from the data warehouse, and means for grouping the first and second sales promotion data to define third promotion data corresponding to a third sales promotion.