As a new management idea generated in the electronic commerce environment, collaborative commerce extend the range of business administration from a single enterprise to business partners. Business intelligence helps enterprises integrate data efficiently, and then turn the data into valuable information for enterprises, thus making the enterprise acquire knowledge and improve the ability of enterprise management and decision-making. The collaborative mechanism based on the business intelligence system makes the generation of information more intelligent and initiative. This paper identifies the operating mechanism of collaborative commerce based on business intelligence system, and we explore the application of business intelligence system in the retail industry.