Abstract:Data warehouse and on-line analytical processing (OLAP) are integral parts of the decision support system (DSS).Data warehouse provides basis for data query and analysis while OLAP focuses on customer interaction,quick response and presentation of multidimensional view.Taking the chain store distribution decision system as an example a solution program of the decision support system based on data warehouse and OLAP is described and the ways to perfect the system are discussed.